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