Home > mailing lists

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

From	JORGE MALDONADO
Subject	Split the result of a query in 2 rows
Date	March 4, 2015 21:28:30
Msg-id	CAAY=A79PMCTw=GskMa8bdxCsu8FYUHOT4vrcTUzCCU9KSw776A@mail.gmail.com Whole thread Raw
Responses	Re: Split the result of a query in 2 rows Re: Split the result of a query in 2 rows Re: Split the result of a query in 2 rows
List	pgsql-novice

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

From: Lacey Powers
Date: 21 February 2015, 21:02:42
Subject: Re: Hash function

From: David G Johnston
Date: 04 March 2015, 21:46:52
Subject: Re: Split the result of a query in 2 rows