Message-ID: <452EC4E4.90107@presinet.com>
Date: Thu, 12 Oct 2006 15:42:44 -0700
From: Bricklen Anderson <banderson@presinet.com>
User-Agent: Thunderbird 1.5.0.7 (X11/20060922)
MIME-Version: 1.0
To: Gerardo Herzig <gherzig@fmed.uba.ar>
Cc: pgsql-sql@postgresql.org
Subject: Re: spliting a row to make several rows
References: <452EBF1F.7070505@fmed.uba.ar>
In-Reply-To: <452EBF1F.7070505@fmed.uba.ar>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Gerardo Herzig wrote:
> 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
> 

dev=#select split_to_rows('aa--bb--cc','--');

split_to_rows
---------------
  aa
  bb
  cc
(3 rows)


This function was written by David Fetter,
http://archives.postgresql.org/pgsql-general/2005-12/msg00080.php

CREATE OR REPLACE FUNCTION split_to_rows(TEXT,TEXT) RETURNS SETOF TEXT
AS $$
     SELECT (string_to_array($1, $2))[s.i]
     FROM generate_series(
         1,
         array_upper(string_to_array($1, $2), 1)
     ) AS s(i);
$$ language sql strict;