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

In response to

• Is it possible... at 2004-08-24 15:47:43 from Uwe C. Schroeder

pgsql-general by date

Next:	From: Richard Huxton	Date: 2004-08-24 16:10:44
	Subject: Re: Is it possible...
Previous:	From: Gaetano Mendola	Date: 2004-08-24 16:02:17
	Subject: Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow