[GENERAL] Varchar -> Integer[] conversion

2007-08-25 Thread Gustavo Tonini
Someone have a function that converts a string literal (a varchar argument) to an integer array? Thanks, Gustavo. PS: Please CC to me. I'm not subscribed at list. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Argument type list

2007-08-23 Thread Gustavo Tonini
anks, Gustavo. On 8/23/07, Erik Jones <[EMAIL PROTECTED]> wrote: > On Aug 23, 2007, at 1:27 PM, Tom Lane wrote: > > > Erik Jones <[EMAIL PROTECTED]> writes: > >> On Aug 23, 2007, at 11:56 AM, Gustavo Tonini wrote: > >>> I want to create a function that rece

[GENERAL] Argument type list

2007-08-23 Thread Gustavo Tonini
I want to create a function that receive a list argument and filter data with IN operator. Example: CREATE OR REPLACE FUNCTION "public"."ffoo" (list ???) RETURNS VOID AS $body$ BEGIN select * from foo where foo_column in list; END; $body$ LANGUAGE 'plpgsql' ; I played with arrays but I got no s