I'm trying to return TEXT[] type from my_func() with a RETURN QUERY EXECUTE and VALUES statement. But calling my_func() which has " in '' got the error as shown below: CREATE FUNCTION my_func() RETURNS SETOF TEXT[] AS $$ BEGIN --…
I'm working on a TypeScript project where I need to compare two objects with potentially nested structures and identify the fields that have changed between them. For instance, consider an old object oldObject with fields like name, age, city, friends…
I'm working on this Math recursive question. What is needed to do is when I put in 0 to the console, it should display the answer then take that answer put into the equation and display the next answer, it…
let arr = [1, 2, 3, 4, 5]; for (let i = 0; i <= arr.length - 1; i++) { let ar = arr.splice(i, 1); console.log(ar.flat()) } I have an array. 1 kills 2, 3 kills 4 like and array…
Here is the input that should be converted to JSON format as given below. {RS0004036}:{0;3}:{0000003AB;0000003BC}_{RS0004036}:{3;3}:{0000003DE;0000003FG}_{RS0004036}:{1;2}:{0000003HI;0000003JK} The code should read the above input, will create a JSON return string as follows. The returning JSON will return store which will be only…
We have UI editor from which user can select any number of days. If the user selects continuous days, those are represented by dashes or hyphens, but if non-continuous days are selected then those are represented by commas.. eg -…
I have 5 indexed arrays in an object and I want to access these array keys to display them. I understand that the last two lines are causing issues. I've searched for an hour and haven't found why it doesnt…
Here is the input that should be converted to JSON format as given below. '{RS0004036}:{1;2}:{0000003AB;0000003BC}_{RS0004036}:{0;3}:{0000003DE;0000003FG}_{RS0004036}:{3;3}:{0000003HI;0000003JK}' Target JSON should be like this. The code should read the above input, will create a JSON return string as follows. The returning JSON will…
I have a string: this.sentence = 'I have a brother, sister, a dog, and a cat.' I want to convert it into an array so that each word and each punctuation mark is a separate value. Using .split(" ") gives…
this might be a difficult question, but I'm trying to do the following: Take an input string i which i want to be a unix timestamp including miliseconds Convert this to an int64 byte array, but i can only do…