On 06/11/2007, Toni Casueps <casueps@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
