Tom Lane wrote:
Josh Berkus <[EMAIL PROTECTED]> writes:
Would it be a worth it for us to implement a non-standard simple syntax
sugar on top of WITH RECURSIVE? Or, at least, something like
CONNECT_BY()?
The Oracle syntax only *looks* simple. When you start to study it
you realize that it's a horrid, messy kluge.
Yeah. I was actually thinking more of something like:
<table_identifier> RECURSIVE JOIN ON <column_expression> <operator>
<column_expression>
... which would be a pretty good simplest-case syntax.
When I mentioned connect_by() I was referring to Joe's function, not
Oracle's syntax, which I think is awful.
--Josh
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
