Re: generic crosstab

On 06/11/2007, Toni Casueps <casueps(at)hotmail(dot)com> wrote:
>
> I'm using the PostgreSQL crosstab functions to do something like this:
>
> From this table ...
>
> a x 10
> b x 13
> a y 11
> b y 17
>
>
> ... I get:
>
> x y
> a 10 11
> b 13 17
>
>
> To get the second table I have to specify the field list when I call the crosstab function (in this example it would be AS t(x integer, y integer))
> My problem arises when that field list changes, for example when someone inserts a record in the first table with a new value, for example "z". In that case I have to change my queries to AS t(x integer, y integer, z integer)
>
> Do you know how to declare a "generic" field list, or some other library similar to crosstab?
>

Hello

it isn't possible. PostgreSQL'SQL is strict typed language :(.

Pavel Stehule

> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>