John Elrick wrote:
>
> A recursive trigger would handle this issue nicely...a way of SELECTing
> a hierarchy would also be nice, but I believe there is nothing
> standardized for that particular operation.
>
As Nicolas said, SQL:1999 defines a standard method of doing this. It
uses a WITH RECURSIVE clause as a prefix to a SELECT. It hasn't been
widely implemented, but I believe that IBM's DB2 supports this mechanism.
HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
