> My query contains select ..,
> sum_unitvalues(qty,unitid),sum_units(unitid),...
> then the units returned do not have to be known in advance, which is
> important in this specific project.
>
To give an example of my required result set:
unitid
1 = mm
2 = inch
3 = ft
4 = gram
create table test(id serial primary key, qty numeric(12,4), unitid int);
insert into test(qty,unitid)
values(100,2),(200,2),(5,3),(20,1),(800,4)
select sum_unitvalues(qty,unitid) as qty, sum_units(unitid) as unitid
from test where unitid<>4;
qty | unitid
----------------------------
9124 | 1
select sum_unitvalues(qty,unitid) as qty, sum_units(unitid) as unitid
from test where unitid not in (1,4);
qty | unitid
----------------------------
360 | 2
select sum_unitvalues(qty,unitid) as qty, sum_units(unitid) as unitid
from test;
qty | unitid
----------------------------
NULL | NULL