JORGE MALDONADO <jorgemal1...@gmail.com> hat am 24. Dezember 2012 um 17:30 geschrieben: > I have a record with the following fields: > > id1, id2, id3, id4, price1, price2, price3, price4 > > I would like to write a SELECT statement in order to get 4 records: > > id, price (record that comes from id1 and price 1) > id, price (record that comes from id2 and price 2) > id, price (record that comes from id3 and price 3) > id, price (record that comes from id4 and price 4) > > I will very much appreciate any suggestion. > > Respectfully, > Jorge Maldonado
select id1 as id, price1 as price union all select id2, price2 union all select id3, ... you got it? Andreas -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql