7.0.3 and 7.1.3 different results?

From: Joel Mc Graw <jpmcgraw1(at)home(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: 7.0.3 and 7.1.3 different results?
Date: 2001-10-01 21:14:35
Message-ID: 3BB8DCBB.8C96D5AC@home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Lebedev 2001-10-02 00:45:21 Re: On Differing Optimizer Choices ( Again)
Previous Message Philip Hallstrom 2001-10-01 18:08:48 Re: PostgreSQL downloads