Uwe C. Schroeder wrote:
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

Reply via email to