Re: foreign key reference on array elements? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: foreign key reference on array elements?
Date
Msg-id 20020516181342.B1443-100000@megazone23.bigpanda.com
Whole thread Raw
In response to foreign key reference on array elements?  (Lev Lvovsky <lists1@sonous.com>)
List pgsql-general
On Thu, 16 May 2002, Lev Lvovsky wrote:

> dunno if this is possible, but...
>
> from an array, is it possible to check for a foreign key in another table
> that is not an array?  do I need to make a function for this?

You mean check to see that the array elements reference an existing row?
You'd need to make your own triggers to handle that, although you may
want to consider using a details table rather than an array depending on
what you're doing.



pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: simple yet complex join
Next
From: Stephan Szabo
Date:
Subject: Re: if !NULL ?