Tom Lane wrote:
I would think this is overkill, except I've made the same darn mistake one time too many. It seems clear to me that a lot of other people will make it too, and if the error message isn't more helpful a lot of time will get wasted. Barring loud objections, I'm gonna go change it.
Yes, please. At least DB2 allows recursive queries without the "RECURSIVE" keyword, just "WITH" is enough. Without a hint, anyone migrating from such a system will spend hours looking at the query, seeing nothing wrong.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
