Skip site navigation (1) Skip section navigation (2)

Re: Is it possible...

From: Joe Conway <mail(at)joeconway(dot)com>
To: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is it possible...
Date: 2004-08-24 16:07:42
Message-ID: 412B67CE.6010204@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-general
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group