Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 389ACB53E85 for ; Fri, 25 May 2012 09:57:49 -0300 (ADT) Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SXu5U-00016N-58 for pgsql-sql@postgresql.org; Fri, 25 May 2012 12:57:48 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1SXu5G-0007rV-Ri for pgsql-sql@postgresql.org; Fri, 25 May 2012 05:57:34 -0700 Date: Fri, 25 May 2012 05:57:34 -0700 (PDT) From: danycxxx To: pgsql-sql@postgresql.org Message-ID: <1337950654848-5710005.post@n5.nabble.com> In-Reply-To: <862d618c8d42e3a0b300d1f7be966d77@neslonek.homeunix.org> References: <1337936621862-5709987.post@n5.nabble.com> <862d618c8d42e3a0b300d1f7be966d77@neslonek.homeunix.org> Subject: Re: Select row cells as new columns MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.9 (/) X-Archive-Number: 201205/90 X-Sequence-Number: 36638 Yes, I've looked at it, but id doesn't create the desired output. After more research I've found that I my design is similar to Entity, Attribute and Value(EAV) design and I think I have to redesign. Any suggestion regarding EAV? Is there any other approach? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Select-row-cells-as-new-columns-tp5709987p5710005.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com.