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
ASt(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?
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/