-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > I think this approach have a problem (almost with my data), i have a > somewhat large number of different sizes, about 200 or so (although i > have a presented a limited example i now). Thanks anyway by the > alternative way to do it Andreas. > Actually the crosstab function won't work for you if you need something more then the basic one or two columns. (IIRC). Building a dynamic sql string such as Andreas suggested will always give you exactly what you want. Sim -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkmqp+wACgkQjDX6szCBa+r2IgCgpEGq1obqHtWcbbbdchm2cT1e ShEAniOg/qut+DXQS2mwvSvAMtiE7eOi =wKIf -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
