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
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
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
On Sun, Oct 21, 2012 at 5:46 AM, Chitra Creta wrote:
> Thank you all.
>
> Ryan, would you mind sharing your one-time function to move it?
>
> Merlin, what are your suggestions to improve query performance?
>
> Shaun, thank you. I will look into facts and dimensions should all else
> fail.
>
> Chr
Thank you all.
Ryan, would you mind sharing your one-time function to move it?
Merlin, what are your suggestions to improve query performance?
Shaun, thank you. I will look into facts and dimensions should all else
fail.
Chris, would you mind giving me an example of what you mean by your log,
a
