Re: Selecting values from comma separated string

Here I come again to ask how can I pass an array of values to a pgsql
function when I call this function from a delphi program for example.

Nacef

On Wed, Aug 26, 2009 at 3:05 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> writes:
> > In response to Nacef LABIDI :
> >> I want to write a function that takes as param a comma separated values
> string
> >> and perform a select matching these values.
>
> > Use EXECUTE sql_string,
>
> Safer to use string_to_array, for instance
>
> ... WHERE id = ANY(string_to_array('1,3,7,8', ',')::int[]) ...
>
> Of course this just begs the question of why the OP doesn't use an
> array in the first place.
>
> regards, tom lane
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>

--
Nacef LABIDI
nacef(dot)l(at)gmail(dot)com