Postgres Pro
Downloads
Home   >   mailing lists

Re: Common table expression - parsing questions - Mailing list pgsql-sql

From Thomas Kellerer
Subject Re: Common table expression - parsing questions
Date
Msg-id ha9e9c$p9v$1@ger.gmane.org
Whole thread Raw
In response to Common table expression - parsing questions  (the6campbells <the6campbells@gmail.com>)
Responses Re: Common table expression - parsing questions  (the6campbells <the6campbells@gmail.com>)
Re: Common table expression - parsing questions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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. 

As far as I can tell there are two DBMS that require it (Postgres, Firebird) and two that don't (SQL Server and Oracle
withthe newest release)
 

Thomas

pgsql-sql by date:

Previous
From: Andreas
Date:
Subject: Need even more magic. Now for tricky counts.
Next
From: the6campbells
Date:
Subject: Re: Common table expression - parsing questions