Re: [GENERAL] variadic function, query "in", help with syntax/function

2012-10-21 Thread Scott Ribe
On Oct 21, 2012, at 11:01 AM, Pavel Stehule wrote: > Hello > > 2012/10/21 Scott Ribe : >> 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

Re: [GENERAL] variadic function, query "in", help with syntax/function

2012-10-21 Thread Pavel Stehule
Hello 2012/10/21 Scott Ribe : > 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; > create fun

[GENERAL] variadic function, query "in", help with syntax/function

2012-10-21 Thread Scott Ribe
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_r...@elevated-dev.com http://www.ele