Tom Lane wrote:
> Josh Berkus <josh(at)agliodbs(dot)com> 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