Home > mailing lists

7.0.3 and 7.1.3 different results? - Mailing list pgsql-sql

From	Joel Mc Graw
Subject	7.0.3 and 7.1.3 different results?
Date	October 2, 2001 13:23:19
Msg-id	3BB8DCBB.8C96D5AC@home.com Whole thread Raw
Responses	Re: 7.0.3 and 7.1.3 different results? (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-sql

Tree view

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.

pgsql-sql by date:

From: Tom Lane
Date: 02 October 2001, 04:20:21
Subject: Re: using SQL to evaluate arbitrary expressions?

From: "Pat M"
Date: 02 October 2001, 13:55:51
Subject: Function return rows?

7.0.3 and 7.1.3 different results? - Mailing list pgsql-sql

Previous

Next