Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B71F09FB3D2 for ; Thu, 12 Oct 2006 19:34:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 25269-01 for ; Thu, 12 Oct 2006 19:34:03 -0300 (ADT) X-Greylist: delayed 00:18:52.408201 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 411C89FB403 for ; Thu, 12 Oct 2006 19:34:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from fmed.uba.ar (mail.fmed.uba.ar [157.92.152.1]) by svr4.postgresql.org (Postfix) with ESMTP id 476D55AF897 for ; Thu, 12 Oct 2006 22:15:06 +0000 (GMT) Received: from [157.92.155.58] (unknown [157.92.155.58]) by fmed.uba.ar (Postfix) with ESMTP id AD8D9418E56 for ; Thu, 12 Oct 2006 19:24:14 -0300 (ART) Message-ID: <452EBF1F.7070505@fmed.uba.ar> Date: Thu, 12 Oct 2006 19:18:07 -0300 From: Gerardo Herzig User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: spliting a row to make several rows Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.692 tagged_above=0 required=5 tests=AWL, SPF_SOFTFAIL X-Spam-Level: X-Archive-Number: 200610/120 X-Sequence-Number: 26509 Hi all: What a want to do is something like this: suppose i have this record aa--bb--cc I guess if im able to do some sql/plsql procedure to get something like it aa bb cc (3 records, rigth?) Thanks a lot Gerardo