Re: Split the result of a query in 2 rows

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
<http://blog.lerner.co.il/turning-postgresql-arrays-rows-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;

Note that's using one query using a CTE (
http://www.postgresql.org/docs/9.3/static/queries-with.html)

Frank

On Wed, Mar 4, 2015 at 12:28 PM, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
wrote:

> I have a very simple query to a single table as follows:
>
> SELECT field1, field2 FROM tbl_table ORDER BY field1
>
> Is it possible to "split" the results so field1 is displayed in one row
> and field2 in another row?
>
> Best regards,
> Jorge Maldonado
>