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: One Ring to Bind Them

Re: One Ring to Bind Them

From: Tony Douglas <tonyisyourpal_at_netscape.net>
Date: 21 Jun 2004 07:07:56 -0700
Message-ID: <bcb8c360.0406210607.424faf2e@posting.google.com>


"Anthony W. Youngman" <wol_at_thewolery.demon.co.uk> wrote in message news:<j$hPkhMcm30AFwso_at_thewolery.demon.co.uk>...

<snip>

> Actually, I've just reread what you wrote. Do you mean "constraint" as
> in a relational constraint - foreign-key type stuff; or as a general
> term for enforcing integrity. I was thinking the latter, hence my
> reference to triggers, but I suspect you might be meaning the former. If
> you did mean the former, Pick doesn't have them because it achieves the
> same effect as a side-effect of its implementation. So the fact that
> relational needs them is de-facto a hindrance relative to Pick.
>

Additionally, with regards to your last point - how does Pick have "foreign-key type stuff" as a "side-effect of its implementation" ? Is this down to its multi-valuedness ? What happens if you use Pick in faux-relational mode - do you just lose this kind of constraint ?

> Cheers,
> Wol

Received on Mon Jun 21 2004 - 09:07:56 CDT

Original text of this message

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