Re: [GENERAL] Tip: Transposing rows using generate_series()

Look at unnest function. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Tip: Transposing rows using generate_series()

Hi all, The recent discussion about generate_series() made me realise you can use it to transpose rows; meaning you can turn columns of each row into separate rows. Here's an example: CREATE TABLE foobarbaz( foo text, bar text, baz int ); INSERT INTO foobarbaz (foo, bar, baz) VALUES ('Foo', 'B