Received: from www.actarg.com (root@[209.180.91.25]) by hub.org (8.9.3/8.9.1) with ESMTP id NAA89430 for ; Thu, 22 Apr 1999 13:22:09 -0400 (EDT) (envelope-from kyle@actarg.com) Received: from tao.actarg.com (root@tao.actarg.com [192.168.1.1]) by www.actarg.com (8.8.7/8.8.7) with ESMTP id LAA08800 for ; Thu, 22 Apr 1999 11:24:20 -0600 Received: from actarg.com (kyle@chi.actarg.com [192.168.2.16]) by tao.actarg.com (8.8.7/8.8.7) with ESMTP id LAA17174 for ; Thu, 22 Apr 1999 11:27:36 -0600 Sender: kyle@actarg.com Message-ID: <371F5BBF.874251FD@actarg.com> Date: Thu, 22 Apr 1999 11:26:23 -0600 From: Kyle Bateman Organization: Action Target Inc. X-Mailer: Mozilla 4.08 [en] (X11; I; Linux 2.0.36 i686) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: sum of two queries Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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@actarg.com