Re: arrays of foreign keys

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: arrays of foreign keys
Дата
Msg-id 08D6AF7A-52ED-40DC-8004-CA02753EEF2D@seespotcode.net
обсуждение исходный текст
Ответ на arrays of foreign keys  (Max <mlavenne@gmail.com>)
Список pgsql-general
On Sep 7, 2007, at 18:47 , Max wrote:

> I am trying to create a table with an array containing foreign keys.
> I've searched through the documentation and couldn't find a way to do
> so.

It's because this is not how relational databases are designed to
work. From the server's point of view, an array is an opaque
structure, to be treated as a whole. You're working against the
system here.

> I know I can solve my problem with the following table:

And this is how you should do it.

Michael Glaesemann
grzm seespotcode net



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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: arrays of foreign keys
Следующее
От: "Rodrigo De León"
Дата:
Сообщение: Re: audit sql queries