generic crosstab
| От | Toni Casueps |
|---|---|
| Тема | generic crosstab |
| Дата | |
| Msg-id | BLU109-W4705AF36D8BB4966D60BBFAD890@phx.gbl обсуждение исходный текст |
| Ответы |
Re: generic crosstab
Re: generic crosstab |
| Список | pgsql-general |
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/
В списке pgsql-general по дате отправления: