Search Postgresql Archives

Re: arrays of foreign keys

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux