Re: [GENERAL] arrays of foreign keys

2007-09-14 Thread Max
Hello, Thanks everyone for your input. Then, it sounds like I won't use an array of foreign keys. I was just curious about the array functionality. However, I didn't think about setting up a view above the intermediary table with an array_accum, now I have never heard of array_accum. I did some r

Re: [GENERAL] arrays of foreign keys

2007-09-10 Thread Josh Trutwin
On Fri, 07 Sep 2007 23:47:40 - Max <[EMAIL PROTECTED]> wrote: > Hello, > > And pardon me if I posted this question to the wrong list, it seems > this list is the most appropriate. > > I am trying to create a table with an array containing foreign keys. > I've searched through the documentati

Re: [GENERAL] arrays of foreign keys

2007-09-10 Thread Albe Laurenz
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. > > Is this something that one can do? > > Basically, I have two tables: > > create table user ( > user_id serial, > login varchar(5

Re: [GENERAL] arrays of foreign keys

2007-09-10 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/07/07 18:47, Max wrote: > Hello, > > And pardon me if I posted this question to the wrong list, it seems > this list is the most appropriate. > > I am trying to create a table with an array containing foreign keys. > I've searched through the d

Re: [GENERAL] arrays of foreign keys

2007-09-10 Thread Michael Glaesemann
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 ar

Re: [GENERAL] arrays of foreign keys

2007-09-10 Thread David Fetter
On Fri, Sep 07, 2007 at 11:47:40PM -, Max wrote: > Hello, > > And pardon me if I posted this question to the wrong list, it seems > this list is the most appropriate. > > I am trying to create a table with an array containing foreign keys. > I've searched through the documentation and couldn'

[GENERAL] arrays of foreign keys

2007-09-10 Thread Max
Hello, And pardon me if I posted this question to the wrong list, it seems this list is the most appropriate. 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. Is this something that one can do? Basical