Re: What databases have taught me

Bruno Desthuilliers wrote:
[...]
>. And all the litterature that keep on
> saying RA can't do this.

You are quite right that the RA (or the predicate logic of which the RA is a dialect) cannot express transitive closure. It has to be extended with some kind of the TC operator.

There is a standard (SQL'99) TC closure operator called 'recursive query'. Both DB2 and SQL Server 2005 have it. Oracle has had the proprietary 'connect by' since probably version 7. As far as I remember, Postgress used to have a patch that implemented the Oracle 'connect by'.

> bruno desthuilliers
> python -c "print '_at_'.join(['.'.join([w[::-1] for w in p.split('.')]) for
> p in 'onurb_at_xiludom.gro'.split('@')])"
Received on Fri Jun 23 2006 - 20:46:09 CEST