Re: Split the result of a query in 2 rows - Mailing list pgsql-novice

So:

If the original result set returned 1 row with 2 columns the new solution would return 2 rows with 1 column?

If the original result set returned 100 row with 3 columns the new solution would return 300 rows (1 row gets turned into 3 rows * 100 rows = 300)?

I would use unnest. Something like this (untested):

​

 

WITH temp_table AS (

  SELECT ARRAY(SELECT field1, field2 FROM tbl_table ORDER BY field1) AS prepared_fields;

)

  SELECT UNNEST(prepared_fields) FROM temp_table;