Re: index doesn't work for null?

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@pilosoft.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