Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37016=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1TsImU-0002Q6-02
	for pgsql-sql@arkaria.postgresql.org; Mon, 07 Jan 2013 19:54:46 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37016=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1TsImS-0002Rp-Tq
	for pgsql-sql@arkaria.postgresql.org; Mon, 07 Jan 2013 19:54:44 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <scrawford@pinpointresearch.com>) id 1TsImL-0002Lk-IL
	for pgsql-sql@postgresql.org; Mon, 07 Jan 2013 19:54:37 +0000
Received: from cerberus.pinpointresearch.com ([66.7.238.130]
	helo=polaris.pinpointresearch.com)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <scrawford@pinpointresearch.com>) id 1TsImI-0003Ir-GC
	for pgsql-sql@postgresql.org; Mon, 07 Jan 2013 19:54:37 +0000
Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com
	[192.168.1.179])
	by polaris.pinpointresearch.com (Postfix) with ESMTP id E49D9E00EC84;
	Mon,  7 Jan 2013 11:54:31 -0800 (PST)
Message-ID: <50EB27F7.8020900@pinpointresearch.com>
Date: Mon, 07 Jan 2013 11:54:31 -0800
From: Steve Crawford <scrawford@pinpointresearch.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
To: emilu@encs.concordia.ca
CC: pgsql-sql@postgresql.org
Subject: Re: Split a string to rows?
References: <50EB25B5.5020502@encs.concordia.ca>
In-Reply-To: <50EB25B5.5020502@encs.concordia.ca>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 01/07/2013 11:44 AM, Emi Lu wrote:
>
> Is there a function to split a string to different rows?...
>
>
Have you looked at regexp_split_to_table?

Cheers,
Steve


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql