Re: [BUGS] Optimalisation options change query results

2001-04-27 Thread Marcin Zukowski
> 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

Re: [BUGS] Optimalisation options change query results

2001-04-27 Thread Tom Lane
[EMAIL PROTECTED] 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

[BUGS] Optimalisation options change query results

2001-04-27 Thread pgsql-bugs
Marcin Zukowski ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Optimalisation options change query results Long Description I had a problem with retrieving data when some of the multi-column index fields were NULL - it was al