arrays of foreign keys

[Max <mlavenne@xxxxxxxxx>]

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?

Basically, I have two tables:

create table user (
  user_id serial,
  login varchar(50) primary key,
  tags integer[]-- this is where the problem lies
);

create table tag (
  tag_id serial,
  name varchar(50) primary key
);

I would like the user.tags field to be a list of foreign keys (tag_ids
specifically).

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

create table user_tag (
  user_id integer,
  tag_id integer,
  foreign key (user_id) references table user(user_id) on delete
cascade,
  foreign key (tag_id) references table tag(tag_id) on delete cascade,
  primary key (user_id,tag_id)
);

But I would really like to avoid doing that.

Is there a solution to this problem with arrays of foreign keys, and
if so, how does one do that?

Thanks for any help.

Max


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings