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: Distributed foreign keys (was Re: Category Types)

Re: Distributed foreign keys (was Re: Category Types)

From: Jonathan Leffler <jleffler_at_earthlink.net>
Date: Tue, 08 Jul 2003 05:03:44 GMT
Message-ID: <QgsOa.88714$Io.7753795@newsread2.prod.itd.earthlink.net>


Paul Vernon wrote:
> Assuming the type INTEGERS_0-2^32 is already know to the DBMS (say as a
> relational expression over some inbuilt BIT type?), then
> INTEGER_0-2^32_INTERVALS could be defined by
>
> INSERT INTO RE_TYPES ( Type_Name, Type_RE_Defn)
> VALUES ( "INTEGER_0-2^32_INTERVALS"
> , "SELECT i.i as Bound_Lower, j.i as Bound_Upper
> FROM INTEGERS_0-2^32 i, INTEGERS_0-2^32 j
> WHERE i.i >= j.i"
> )

Typo?

That says i.i is the lower bound, but it must be greater than or equal to the j.i, the upper bound?

-- 
Jonathan Leffler                   #include <disclaimer.h>
Email: jleffler_at_earthlink.net, jleffler_at_us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
Received on Tue Jul 08 2003 - 00:03:44 CDT

Original text of this message

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