2009/8/26 Nacef LABIDI <nace...@gmail.com>: > 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. >
the driver have to support it. But why? simply you can use varchar and string_to_array function. Pavel > Nacef > > > > On Wed, Aug 26, 2009 at 3:05 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> >> "A. Kretschmer" <andreas.kretsch...@schollglas.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@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-sql > > > > -- > Nacef LABIDI > nace...@gmail.com > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql