Re: Can arrays reference primary keys in CREATE TABLE?

Luis Sousa wrote:
> Richard Huxton wrote:
> 
>> On Friday 09 May 2003 10:21 pm, Filipe Bonjour wrote:
>>  
>>
>>> Hi,
>>>
>>> I'm a rather new SQL user, and I found interesting that you can
>>> use "references" to make sure that a value inserted in a table is a
>>> primary key from another table. Something like:
>>>   
>>
>>
>> Yep - referential integrity is vital.
>>
> I used a trigger to get referential integrity.
> So, on update or insert, it fires the function that's going to read the 
> new array and check if really exists on the other table

And what happens on UPDATE or DELETE to the primary key table?

You used a trigger to check something, but unless you have a full set of
said triggers and they do the locking as well, you do not have
referential integrity.


Jan


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #