Skip site navigation (1) Skip section navigation (2)

Re: WITH support

From: Hubert FONGARNAND <informatique(dot)internet(at)fiducial(dot)fr>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Edwin Ramirez <edwin(dot)ramirez(at)mssm(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: WITH support
Date: 2006-12-29 09:06:31
Message-ID: 1167383191.8632.8.camel@hublinux.fidudev.fr (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello,

I can see : WITH RECURSIVE hierarchical queries (Jonah H. Harris) in :

http://developer.postgresql.org/index.php/Todo:WishlistFor83

GREAT!!! 

Such feature is very important, because it is supported in most of
commercial database
SQL Server 2003 support WITH RECURSIVE
DB2 support it too (WITH RECURSIVE has been invented by IBM)
Oracle support CONNECT BY (which is not standard, but very easier to use
compare to WITH RECURSIVE)

PostGreSQL would be the first opensource database supporting
hierarchical queries...

Today we use the "CONNECT BY" patch made by evgen potemkin
http://gppl.moonbone.ru/, it works well on 8.1...
But we are ready to drop it if WITH RECURSIVE is integrated!!!

It would be great to open a page on the developper wiki on this subject?

Sincerely

Hubert FONGARNAND

 _____ _     _            _       _   ____  _         __  __ _             
|  ___(_) __| |_   _  ___(_) __ _| | / ___|| |_ __ _ / _|/ _(_)_ __   __ _ 
| |_  | |/ _` | | | |/ __| |/ _` | | \___ \| __/ _` | |_| |_| | '_ \ / _` |
|  _| | | (_| | |_| | (__| | (_| | |  ___) | || (_| |  _|  _| | | | | (_| |
|_|   |_|\__,_|\__,_|\___|_|\__,_|_| |____/ \__\__,_|_| |_| |_|_| |_|\__, |
                                                                     |___/ 




Le jeudi 28 décembre 2006 à 22:52 -0500, Bruce Momjian a écrit :

> Edwin Ramirez wrote:
> > Hello,
> > 
> > What is the status of supporting the "WITH" keyword?
> 
> I see these TODO items:
> 
> 	* Add SQL99 WITH clause to SELECT
> 	* Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT
> 
> Are they the same item?  Someone has said they will do RECURSIVE for
> 8.3, but there is no guarantee.
> 
> 
_______________________________________________
Ce message et les ventuels documents joints peuvent contenir des informations confidentielles.
Au cas o il ne vous serait pas destin, nous vous remercions de bien vouloir le supprimer et en aviser immdiatement l'expditeur. 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.
Les communications sur internet n'tant pas scurises, l'intgrit de ce message n'est pas assure et la socit mettrice ne peut tre tenue pour responsable de son contenu.

In response to

pgsql-hackers by date

Next:From: Benny AmorsenDate: 2006-12-29 10:42:15
Subject: Re: effective_cache_size vs units
Previous:From: Jochem van DietenDate: 2006-12-29 08:59:41
Subject: Re: TODO: GNU TLS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group