Perfect. Thanks.
Svenne
Markus Bertheau wrote:
2006/3/19, Svenne Krap <[EMAIL PROTECTED]>:
So it is something like "select xxx(id) from othertable where otherwhere
= 't'" except that it mangles the columns into an array. I have tried to
move the function-call into the fromlist (
2006/3/19, Svenne Krap <[EMAIL PROTECTED]>:
> So it is something like "select xxx(id) from othertable where otherwhere
> = 't'" except that it mangles the columns into an array. I have tried to
> move the function-call into the fromlist (as it is usually done) but I
> seem unsuccessful in getting
Hi.
I have a function that is defined like (which works, sorry for the
pseudocode)
create type xxx as (id,...);
create function calcuate_xxx (integer) returns xxx as $$ select $1,
(select sum(amount) from bigtable where something) as a, (select
sum(amount) from bigtable where some-other-thing
