Quick Links

Split the result of a query in 2 rows

From:	JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To:	pgsql-novice(at)postgresql(dot)org
Subject:	Split the result of a query in 2 rows
Date:	2015-03-04 18:28:25
Message-ID:	CAAY=A79PMCTw=GskMa8bdxCsu8FYUHOT4vrcTUzCCU9KSw776A@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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

Responses

Re: Split the result of a query in 2 rows at 2015-03-04 18:46:45 from David G Johnston
Re: Split the result of a query in 2 rows at 2015-03-04 18:53:03 from Frank Pinto
Re: Split the result of a query in 2 rows at 2015-03-05 01:34:24 from Marcos Almeida Azevedo

Browse pgsql-novice by date

	From	Date	Subject
Next Message	David G Johnston	2015-03-04 18:46:45	Re: Split the result of a query in 2 rows
Previous Message	Lacey Powers	2015-02-21 18:02:37	Re: Hash function