On Fri, 25 May 2012 02:03:41 -0700 (PDT), danycxxx wrote:
[...]
The question:
How can I achive this output?
nume, prenume, cnp, nume anterior, stare civila, ... (as columns -
built
from unique rows from infos)
a , a, .......
b , b, ....... (as rows)
Did you look at crosstab functions?
http://www.postgresql.org/docs/9.1/static/tablefunc.html
Jan
--
professional: http://www.oscar-consult.de
private: http://neslonek.homeunix.org/drupal/
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql