I need to change back into an array to change lines from the array and filter the records. I am using info_schema._pg_expandarray in a SELECT query to get a line copy value in the array. Looking at the following array: "four" [] {i, i, o, t, b} _pg_expandarray leaves 5 rows with 1 row type record: records (I, 1) (i, 2) (o, 3) (t, 4) I have to filter this result set 't' to exclude record records. How can I do this? Should I convert back to the array? What is a way to filter the array directly? Thanks in advance. If your purpose is to create one set of the above rows, but remove the 't' in the line So, this is the trick: test => Information (i), 'o', 't', 'b' i. N --- --- --- i | 1 mother 2 o | 3b 5 (4 lines) As a side, unless you specifically want to return the index as a second column, then I unnest () information_schema._pg_expandarray () , which does not appear in the document and is probably...
Comments
Post a Comment