parentid firstkey secondkey 1 firstvalue secondvalue 2 firstvalue secondvalue
I hate the idea of writing code that really creates and fills a table, particularly since the original table has a lot of rows.
Is the above doable with a view? Any pointers will be appreciated.
You can do what you want with set returning functions in contrib/tablefunc. See examples towards the end of my recent OSCON presentation:
http://www.joeconway.com/pres_oscon_2004-r1.pdf
and the source sql:
http://www.joeconway.com/flex.sql
HTH,
Joe
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly