Re: Wrote a connect-by feature

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bertram Scharpf <lists(at)bertram-scharpf(dot)de>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Wrote a connect-by feature
Date: 2007-08-11 12:54:06
Message-ID: 46BDB16E.9000906@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tom Lane wrote:
> "Joshua D. Drake" <jd(at)commandprompt(dot)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-----

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-08-11 14:22:24 Re: Wrote a connect-by feature
Previous Message Pavel Stehule 2007-08-11 05:44:26 Re: regexp_matches and regexp_split are inconsistent