Hi Alex
I have no idea if it is a known issue.
Though "field=null" is not allowed in standard SQL.
The correct statement should be "select from xx where field IS NULL;".
Perhaps it will be handled better (or not).
Best regards
Per-Olof Pettersson
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2001-05-16, 00:21:34, alex(at)pilosoft(dot)com (Alex Pilosov) wrote regarding
index doesn't work for null?:
> I have a bit of a problem:
> 'select from xx where field=null' will always result in seq scan even
when
> there's a [btree] index on the field.
> Is this a known issue?
> -alex
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> http://www.postgresql.org/search.mpl