From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: variadic function, query "in", help with syntax/function |
Date: | 2012-10-21 17:11:11 |
Message-ID: | 59378B90-A499-4BA3-98AD-1DBABE7F18CB@elevated-dev.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Oct 21, 2012, at 11:01 AM, Pavel Stehule wrote:
> Hello
>
> 2012/10/21 Scott Ribe <scott_ribe(at)elevated-dev(dot)com>:
>> 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 function getbatch (variadic ids int8[]) returns setof foobar as $$
> begin
> return query
> select * from foobar where id = any (ids);
> end;
> $$ language plpgsql;
Ah, thanks, I didn't know any worked in that context--I've just used it (and only seen examples) the other way: const_id = any(somecol).
> note, for these single statement function, sql language is better
I greatly simplified it for the question; it's kind of a nasty function that's multiple unions of multiple joins.
--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2012-10-22 07:02:22 | Re: Streaming Replication Server Crash |
Previous Message | Pavel Stehule | 2012-10-21 17:01:05 | Re: variadic function, query "in", help with syntax/function |