pgsql-server/src backend/executor/nodeSubplan. ...

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl(at)postgresql(dot)org 03/01/09 15:50:53

Modified files:
src/backend/executor: nodeSubplan.c
src/backend/nodes: copyfuncs.c equalfuncs.c outfuncs.c
readfuncs.c
src/backend/optimizer/plan: subselect.c
src/backend/parser: gram.y parse_expr.c
src/backend/utils/adt: ruleutils.c
src/include/catalog: catversion.h
src/include/nodes: primnodes.h

Log message:
Adjust parser so that 'x NOT IN (subselect)' is converted to
'NOT (x IN (subselect))', that is 'NOT (x = ANY (subselect))',
rather than 'x <> ALL (subselect)' as we formerly did. This
opens the door to optimizing NOT IN the same way as IN, whereas
there's no hope of optimizing the expression using <>. Also,
convert 'x <> ALL (subselect)' to the NOT(IN) style, so that
the optimization will be available when processing rules dumped
by older Postgres versions.
initdb forced due to small change in SubLink node representation.