Re: foreign key reference on array elements?

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: foreign key reference on array elements?
Дата
Msg-id 20020516181342.B1443-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на foreign key reference on array elements?  (Lev Lvovsky <lists1@sonous.com>)
Список 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 по дате отправления:

Предыдущее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: simple yet complex join
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: if !NULL ?