RE: [SQL] sum of two queries

I use functions. For example:

Create function1 as
'select sum(price) from items';

Create function2 as
'select sum(price) from widgets';

select function1 + function2;

-----Original Message-----
From: Kyle Bateman [SMTP:kyle(at)actarg(dot)com]
Sent: Thursday, April 22, 1999 11:26 AM
To: pgsql-sql(at)postgreSQL(dot)org
Subject: [SQL] sum of two queries

Is there a way to return the sum of two separate queries as in:

select (select sum(price) from items) + (select sum(price) from
widgets))

select 3 + 4 works OK but the parser doesn't like sticking a
subquery in
place
of the numbers.

Is there another way to do this?

kyle(at)actarg(dot)com