variadic function, query "in", help with syntax/function - Mailing list pgsql-general

From Scott Ribe
Subject variadic function, query "in", help with syntax/function
Date
Msg-id 17E66E9E-602C-44D3-A13F-2F1784458B07@elevated-dev.com
Whole thread Raw
Responses Re: variadic function, query "in", help with syntax/function  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Briefly, what would it take to make the following work?

create function getbatch (variadic ids int8[]) returns setof foobar as $$
begin
    return query
        select * from foobar where id in (ids);
end;
$$ language plpgsql;

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Strategies/Best Practises Handling Large Tables
Next
From: Pavel Stehule
Date:
Subject: Re: variadic function, query "in", help with syntax/function