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