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
and the source sql:
In response to
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|