Re: recursive search

From: Kees Nuyt <k.nuyt_at_nospam.demon.nl>
Date: Sun, 11 Sep 2016 02:28:24 +0200
Message-ID: <8299tb92fc845d5ass4lvkq6hdrgiv8sdj_at_dim53.demon.nl>


On Sat, 10 Sep 2016 17:59:35 -0400, Jerry Stuckle <jstucklex_at_attglobal.net> wrote:

>>
>
> J.O., a graph-database is not the same as recursive SQL. Recursive SQL
> has been part of the standard since sometime in the 90's, supported by
> most of the commercial databases, but not MySQL (or MariaDB, AFAIK).
>
> I believe PostGreSQL supports recursive SQL, and the free versions of
> DB2 and Oracle do, also.

Just for completeness: SQLite also supports recursion, with "Common Table Expressions" (CTE).

http://www.sqlite.org/lang_with.html
(hierarchical querie examples included)

-- 
Regards,
Kees Nuyt
Received on Sun Sep 11 2016 - 02:28:24 CEST

Original text of this message