Re: Passing a comma delimited list to a function - Mailing list pgsql-general

From Ezra Epstein
Subject Re: Passing a comma delimited list to a function
Date
Msg-id 4uOdnUwZt7z2D2aiXTWc-g@speakeasy.net
Whole thread Raw
In response to Passing a comma delimited list to a function  (A E <cooljoint@yahoo.com>)
List pgsql-general
Take a look at:
   http://www.postgres.org/docs/current/static/functions-string.html

The split_part() function should do the trick.

== Ezra Epstein

"A E" <cooljoint@yahoo.com> wrote in message
news:20040103181155.67492.qmail@web12103.mail.yahoo.com...
Hi,

I was wondering if there was a function that handles list elements of a
comma delimited list? I need to be able to pass values as a comma delimited
list, count the number of values, and process the value of each.

Did not think it was very efficient to loop through the contents of the list
finding delimiters.

TIA
Alex



pgsql-general by date:

Previous
From: Randall Smith
Date:
Subject: cross-table unique constraint
Next
From: David Helgason
Date:
Subject: SPI question: trying to read from Large Objects from within a function