Skip site navigation (1) Skip section navigation (2)

pgsql: Dept of second thoughts: my first cut at supporting "x IS NOT

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Dept of second thoughts: my first cut at supporting "x IS NOT
Date: 2010-01-03 05:39:09
Message-ID: 20100103053909.1E4F1753FB7@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Dept of second thoughts: my first cut at supporting "x IS NOT NULL" btree
indexscans would do the wrong thing if index_rescan() was called with a
NULL instead of a new set of scankeys and the index was DESC order,
because sk_strategy would not get flipped a second time.  I think
that those provisions for a NULL argument are dead code now as far as the
core backend goes, but possibly somebody somewhere is still using it.
In any case, this refactoring seems clearer, and it's definitely shorter.

Modified Files:
--------------
    pgsql/src/backend/access/nbtree:
        nbtutils.c (r1.96 -> r1.97)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtutils.c?r1=1.96&r2=1.97)

pgsql-committers by date

Next:From: Takahiro ItagakiDate: 2010-01-04 01:06:21
Subject: pgsql: Silence compiler warning about printf format for HANDLE.
Previous:From: Magnus HaganderDate: 2010-01-02 22:47:37
Subject: pgsql: Make ssize_t 64-bit on Win64, for compatibility with for example

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group