Thread: index doesn't work for null?

index doesn't work for null?

From
Alex Pilosov
Date:
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


Re: index doesn't work for null?

From
Per-Olof Pettersson
Date:
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

Re: Re: index doesn't work for null?

From
Alex Pilosov
Date:
Sorry bout that. Actually query does 'is null', I made a mistake in
my post.

-alex

On Tue, 15 May 2001, Per-Olof Pettersson wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>