Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Modeling General Graphs in SQL

Re: Modeling General Graphs in SQL

From: <mikharakiri_nospaum_at_yahoo.com>
Date: 21 Dec 2005 19:17:54 -0800
Message-ID: <1135221474.351644.252410@o13g2000cwo.googlegroups.com>


Bill Karwin wrote:
> Or you might need to assign weights to the edges, and
> return the minimum path between two vertices (wow, that would be a *cool*
> SQL expression that could do that!).

The minimum path query is the same as transitive closure, which is widely believed to be inexpresible by standard SQL. By "standard SQL" I've meant to exclude certain "non-cool" extensions like "connect by" and "recursive with" (even though the latter is formally a part of ANSI SQL). Received on Wed Dec 21 2005 - 21:17:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US