List:General Discussion« Previous MessageNext Message »
From:Jochem van Dieten Date:January 13 2004 7:11pm
Subject:Re: hierarchical records, I need some help!! ;(
View as plain text  
Steve Folly said:
>
> However, I suspect this isn't the full story. Do you also want to
> see  what components make up C003 and D003 in the same query? I
> think you're  after a feature not yet implemented in MySQL - the
> 'CONNECT BY PRIOR'  SELECT statement, just the ticket for
> hierarchical queries.
>
> http://www.mysql.com/doc/en/TODO_future.html - the first item in the
>  list!
>
> Here's an article on how it's used in Oracle - is this what you
> need?
>
> http://www.oracleadvice.com/Tips/pkfktree.htm
>
> BTW - MySQL people - any idea when this will be implemented? I have
> a  couple of projects with hierarchical records which would just
> love this  query!

I most certainly hope this Oracle idiosyncracy will never make it into
MySQL.

The SQL standard defines a different syntax for doing recursive
queries, using WITH RECURSIVE. I see no reason for MySQL to implement
a non-standard way for doing recursive queries when there is a viable
alternative (DB2 already uses WITH conform the SQL standard) that has
standardized behaviour.
I know that a CONNECT BY PRIOR patch is readily available for
PostgreSQL but the PostgreSQL developers reject it exactly because it
does not follow the SQL standard. I think the PostgreSQL developers
are right to do so, non-standard features have caused enough trouble
for application portability as it is.

Jochem




Thread
hierarchical records, I need some help!! ;(Victor Reus12 Jan
  • Re: hierarchical records, I need some help!! ;(Martijn Tonies12 Jan
    • Re: hierarchical records, I need some help!! ;(Victor Reus13 Jan
      • Re: hierarchical records, I need some help!! ;(Steve Folly13 Jan
        • Re: hierarchical records, I need some help!! ;(Jochem van Dieten13 Jan
          • Re: hierarchical records, I need some help!! ;(Steve Folly14 Jan
        • RE: hierarchical records, I need some help!! ;(Matt Griffin13 Jan
  • Re: hierarchical records, I need some help!! ;(Mike13 Jan