Re: WITH support

Hello,<br /><br /> I can see : WITH RECURSIVE hierarchical queries (Jonah H. Harris) in :<br /><br /><a
href="http://developer.postgresql.org/index.php/Todo:WishlistFor83">http://developer.postgresql.org/index.php/Todo:WishlistFor83</a><br
/><br/> GREAT!!! <br /><br /> Such feature is very important, because it is supported in most of commercial database<br
/>SQL Server 2003 support WITH RECURSIVE<br /> DB2 support it too (WITH RECURSIVE has been invented by IBM)<br />
Oraclesupport CONNECT BY (which is not standard, but very easier to use compare to WITH RECURSIVE)<br /><br />
PostGreSQLwould be the first opensource database supporting hierarchical queries...<br /><br /> Today we use the
"CONNECTBY" patch made by <font size="1">evgen potemkin</font> <a
href="http://gppl.moonbone.ru/,">http://gppl.moonbone.ru/,</a>it works well on 8.1...<br /> But we are ready to drop it
ifWITH RECURSIVE is integrated!!!<br /><br /> It would be great to open a page on the developper wiki on this
subject?<br/><br /> Sincerely<br /><br /> Hubert FONGARNAND<br /><br /><table cellpadding="0" cellspacing="0"
width="100%"><tr><td><pre>______     _            _       _   ____  _         __  __ _             
 
|  ___(_) __| |_   _  ___(_) __ _| | / ___|| |_ __ _ / _|/ _(_)_ __   __ _ 
| |_  | |/ _` | | | |/ __| |/ _` | | \___ \| __/ _` | |_| |_| | '_ \ / _` |
|  _| | | (_| | |_| | (__| | (_| | |  ___) | || (_| |  _|  _| | | | | (_| |
|_|   |_|\__,_|\__,_|\___|_|\__,_|_| |____/ \__\__,_|_| |_| |_|_| |_|\__, |
                                                                     |___/ 
</pre><br /></td></tr></table><br /><br /> Le jeudi 28 décembre 2006 à 22:52 -0500, Bruce Momjian a écrit : <blockquote
type="CITE"><pre>
<font color="#000000">Edwin Ramirez wrote:</font>
<font color="#000000">> Hello,</font>
<font color="#000000">> </font>
<font color="#000000">> What is the status of supporting the "WITH" keyword?</font>

<font color="#000000">I see these TODO items:</font>

<font color="#000000">    * Add SQL99 WITH clause to SELECT</font>
<font color="#000000">    * Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT</font>

<font color="#000000">Are they the same item?  Someone has said they will do RECURSIVE for</font>
<font color="#000000">8.3, but there is no guarantee.</font>
<table cellpadding="0" cellspacing="0" width="100%">
<tr>
<td>
<br />
<br />
</td>
</tr>
</table>
</pre></blockquote> _______________________________________________<br />Ce message et les �ventuels documents joints
peuventcontenir des informations confidentielles.<br />Au cas o� il ne vous serait pas destin�, nous vous remercions de
bienvouloir le supprimer et en aviser imm�diatement l'exp�diteur. Toute utilisation de ce message non conforme � sa
destination,toute diffusion ou publication, totale ou partielle et quel qu'en soit le moyen est formellement
interdite.<br/>Les communications sur internet n'�tant pas s�curis�es, l'int�grit� de ce message n'est pas assur�e et
lasoci�t� �mettrice ne peut �tre tenue pour responsable de son contenu.