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@actarg.com]Sent:    Thursday, April 22, 1999 11:26 AMTo:
pgsql-sql@postgreSQL.orgSubject:   [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) fromwidgets))
select 3 + 4 works OK but the parser doesn't like sticking a
subquery inplaceof the numbers.
Is there another way to do this?
kyle@actarg.com