Re: foreign key reference on array elements?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Lev Lvovsky <lists1(at)sonous(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: foreign key reference on array elements?
Date: 2002-05-17 01:15:06
Message-ID: 20020516181342.B1443-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-05-17 01:17:24 Re: if !NULL ?
Previous Message Ken Kachnowich 2002-05-17 00:24:23 CRC error on control file