Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 2856CB53E85 for ; Fri, 25 May 2012 09:45:37 -0300 (ADT) Received: from mout6.freenet.de ([2001:748:100:40::2:8]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SXtte-0000mb-UV for pgsql-sql@postgresql.org; Fri, 25 May 2012 12:45:36 +0000 Received: from [195.4.92.141] (helo=mjail1.freenet.de) by mout6.freenet.de with esmtpa (ID jan.lentfer@freenet.de) (port 25) (Exim 4.76 #1) id 1SXttR-0007Z9-7h for pgsql-sql@postgresql.org; Fri, 25 May 2012 14:45:21 +0200 Received: from localhost ([::1]:40327 helo=mjail1.freenet.de) by mjail1.freenet.de with esmtpa (ID jan.lentfer@freenet.de) (Exim 4.76 #1) id 1SXttQ-0001cs-5b for pgsql-sql@postgresql.org; Fri, 25 May 2012 14:45:20 +0200 Received: from [195.4.92.13] (port=41563 helo=3.mx.freenet.de) by mjail1.freenet.de with esmtpa (ID jan.lentfer@freenet.de) (Exim 4.76 #1) id 1SXtq4-0000Ir-GM for pgsql-sql@postgresql.org; Fri, 25 May 2012 14:41:52 +0200 Received: from p579b72c7.dip.t-dialin.net ([87.155.114.199]:50759 helo=epia.lan.net) by 3.mx.freenet.de with esmtpa (ID jan.lentfer@freenet.de) (port 25) (Exim 4.76 #1) id 1SXtq4-0002G7-81 for pgsql-sql@postgresql.org; Fri, 25 May 2012 14:41:52 +0200 Received: from localhost (localhost [127.0.0.1]) by epia.lan.net (Postfix) with ESMTP id 63E062FAC9737 for ; Fri, 25 May 2012 14:41:51 +0200 (CEST) X-Virus-Scanned: amavisd-new at lan.net Received: from epia.lan.net ([127.0.0.1]) by localhost (epia.lan.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id t2D0bzPKaiFq for ; Fri, 25 May 2012 14:41:34 +0200 (CEST) Received: from neslonek.homeunix.org (localhost [127.0.0.1]) by epia.lan.net (Postfix) with ESMTP id 0CAD02FAC9548 for ; Fri, 25 May 2012 14:41:34 +0200 (CEST) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Date: Fri, 25 May 2012 14:41:33 +0200 From: Jan Lentfer To: Subject: Re: Select row cells as new columns In-Reply-To: <1337936621862-5709987.post@n5.nabble.com> References: <1337936621862-5709987.post@n5.nabble.com> Message-ID: <862d618c8d42e3a0b300d1f7be966d77@neslonek.homeunix.org> X-Sender: Jan.Lentfer@web.de User-Agent: RoundCube Webmail/0.5.3 X-Pg-Spam-Score: 0.8 (/) X-Archive-Number: 201205/88 X-Sequence-Number: 36636 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/