Horton
Menu

Re: Optimalisation options change query results

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: eru@mimuw.edu.pl, pgsql-bugs@postgresql.org
Date: 2001-04-27T12:57:17Z
Lists: pgsql-bugs 
pgsql-bugs@postgresql.org writes:
> Optimalisation options change query results

SQL92 says

              Whether a sort key value that is null is considered greater
              or less than a non-null value is implementation-defined, but
              all sort key values that are null shall either be considered
              greater than all non-null values or be considered less than
              all non-null values.

Postgres appears to me to satisfy the spec.  There's nothing here that
says we can't choose different NULL treatments in different queries...

			regards, tom lane