Received: from femail41.sdc1.sfba.home.com (femail41.sdc1.sfba.home.com [24.254.60.35]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f92ENCn65902 for ; Tue, 2 Oct 2001 10:23:18 -0400 (EDT) (envelope-from jpmcgraw1@home.com) Received: from home.com ([24.1.247.6]) by femail41.sdc1.sfba.home.com (InterMail vM.4.01.03.20 201-229-121-120-20010223) with ESMTP id <20011002142303.QXTU21240.femail41.sdc1.sfba.home.com@home.com> for ; Tue, 2 Oct 2001 07:23:03 -0700 Message-ID: <3BB8DCBB.8C96D5AC@home.com> Date: Mon, 01 Oct 2001 14:14:35 -0700 From: Joel Mc Graw X-Mailer: Mozilla 4.73 [en] (X11; I; FreeBSD 4.1-RELEASE i386) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: 7.0.3 and 7.1.3 different results? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/7 X-Sequence-Number: 4962 A query such as "select sum(pages) from job_documents where delivery_type='print'" returned 0 in version 7.0.3 if there were no rows matching the query. In 7.1.3 the result is NULL if no rows match the query. Why the change? Which result is "correct" according to the SQL standard? I'm running PostgreSQL 7.1.3 on FreeBSD 4.3 (x86). TIA.