Re: avoiding seq scan without duplicating

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: avoiding seq scan without duplicating
Date: 2008-11-07 13:51:03
Message-ID: 08886572B8D0410B88857161F79A561A@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom,

> The proposed transformation is not correct because of the odd behavior
> of NOT IN with respect to nulls.

Thank you.

In this particular case dokumnr is dok table primary key of type int.
bilkaib.dokumnr can contain nulls but this does not affect to result
probably.

So in this case this conversion is probably correct.

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2008-11-07 14:06:15 Re: UPDATE tuples with a sub-select
Previous Message Gerhard Heift 2008-11-07 13:47:55 Re: UPDATE tuples with a sub-select