Re: dynamic crosstab

From: Balázs Klein <Balazs(dot)Klein(at)t-online(dot)hu>
To: "'Joe Conway'" <mail(at)joeconway(dot)com>
Cc: "'Erik Jones'" <erik(at)myemma(dot)com>, "'Tino Wildenhain'" <tino(at)wildenhain(dot)de>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: dynamic crosstab
Date: 2008-02-15 15:59:41
Message-ID: 20080215155941.2B846EC1FC@mail02a.mail.t-online.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Balázs Klein wrote:
> >
> > I was hoping that now with PG supporting plan invalidation it would
> > be possible to return a recordset.
>
> Plan invalidation has nothing to do with it. In Postgres a returned
> recordset can be used as a row source in the FROM clause -- this
> requires data type information to be known at parse time.
>
> Joe

I thought that it includes that the return type can be changed/redefined at runtime. No luck there than.

Thx.
B.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2008-02-15 16:01:24 Re: dynamic crosstab
Previous Message Erik Jones 2008-02-15 15:56:38 Re: dynamic crosstab