Thomas Kellerer <spam_ea...@gmx.net> writes: > the6campbells wrote on 29.09.2009 04:54: >> 2. Do you intend to remove the requirement to include the recursive >> keyword - as other vendors allow
> The standard *requires* the keyword. The reason the standard requires the keyword is that the WITH-name scoping rules are different in the two cases. This means it is possible to construct 100% valid queries that mean different things depending on whether RECURSIVE is present or not. Admittedly, they'd be uncommon corner cases, but the short answer is that an implementation that does not require the keyword will fail to process some standard-conforming queries in a standard-conforming way. IOW, no, we are not going to change this. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql