Re: Foreign keys on array elements

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Foreign keys on array elements
Дата
Msg-id 20050420071721.P42111@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Foreign keys on array elements  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: Foreign keys on array elements  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, 20 Apr 2005, Christopher Kings-Lynne wrote:

> Hi,
>
> Can you put a foreign key constraint on an array column that says that
> each element of the array must match a primary key?

Not currently, because foreign keys are between directly comparable
things.

> If not, is this a TODO perhaps?

Maybe. It's been discussed before IIRC.  Doing the referential actions
might get tricky, and you'd often want to index so that finding the
individual array elements isn't expensive.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: HAVING ...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: HAVING ...