2009/8/26 Nacef LABIDI <[email protected]>: > 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 <[email protected]> wrote: >> >> "A. Kretschmer" <[email protected]> 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 ([email protected]) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-sql > > > > -- > Nacef LABIDI > [email protected] > -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
