• Tom Lane's avatar
    Adjust parser so that 'x NOT IN (subselect)' is converted to · 6bc61fc0
    Tom Lane authored
    '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.
    6bc61fc0
readfuncs.c 20.2 KB