Re: Wrote a connect-by feature - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Wrote a connect-by feature
Date
Msg-id 46BDB16E.9000906@commandprompt.com
Whole thread Raw
In response to Re: Wrote a connect-by feature  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Wrote a connect-by feature  (Andrew Dunstan <andrew@dunslane.net>)
Re: Wrote a connect-by feature  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tom Lane wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
>> Bertram Scharpf wrote:
>>> Wouldn't the release be a good opportunity for providing
>>> this little tool?

> As for whether we could accept this for 8.4, I thought the general
> consensus was that we should implement the SQL-spec WITH syntax.
> The only good reason for supporting CONNECT BY would be to be
> Oracle-compatible, which this patch isn't.  (Being Oracle-compatible
> isn't necessarily good anyway; are we sure they don't have a patent
> on their way of doing this?)

I believe this patch is an update to the table_funcs contrib module.

Sincerely,

Joshua D Drake

> 
> Various people have looked at supporting WITH in the past; IIRC Greg
> Stark has been the most recent contender.  I'd suggest joining forces
> with him if you'd like to make this happen.
> 
>             regards, tom lane
> 


- --
     === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/        UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGvbFuATb/zqfZUUQRAiwTAJ45uppSOwSbk/d0KTENmjkMk6GK0wCgk0Tf
kirMXmEOH9fYSYt+CG9UMIM=
=D9x7
-----END PGP SIGNATURE-----


pgsql-hackers by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: regexp_matches and regexp_split are inconsistent
Next
From: Andrew Dunstan
Date:
Subject: Re: Wrote a connect-by feature