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

pgsql: Improve the tests to see if ScalarArrayOpExpr is strict.

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve the tests to see if ScalarArrayOpExpr is strict.
Date: 2006-02-06 22:21:12
Message-ID: 20060206222112.497809DC97A@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Improve the tests to see if ScalarArrayOpExpr is strict.  Original coding
would basically punt in all cases for 'foo <> ALL (array)', which resulted
in a performance regression for NOT IN compared to what we were doing in
8.1 and before.  Per report from Pavel Stehule.

Modified Files:
--------------
    pgsql/src/backend/optimizer/util:
        clauses.c (r1.207 -> r1.208)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c.diff?r1=1.207&r2=1.208)

pgsql-committers by date

Next:From: Bruce MomjianDate: 2006-02-07 00:26:15
Subject: pgsql: Fix HTML alignment in PQprint.
Previous:From: Teodor SigaevDate: 2006-02-06 15:45:34
Subject: pgsql: Check number of affixes to prevent core dump with zero number of

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