>>>>> "Andrew" == Andrew Gierth <and...@tao11.riddles.org.uk> writes:
Andrew> The easy to catch case, I think, is when the targetlist of the Andrew> IN or NOT IN subquery contains vars of the outer query level Andrew> but no vars of the inner one and no volatile functions. This Andrew> can be checked for with a handful of lines in the parser or a Andrew> couple of dozen lines in a plugin module (though one would have Andrew> to invent an error code, none of the existing WARNING sqlstates Andrew> would do). Actually thinking about this, if you did it in a module, you'd probably want to make it an ERROR not a WARNING, because you'd want to actually stop queries like delete from t1 where x in (select x from table_with_no_column_x); rather than let them run. -- Andrew (irc:RhodiumToad) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
