On Tue, Jun 13, 2006 at 05:01:01PM +0200, Daniel McBrearty wrote: > create table translations ( > id serial primary key > ); > insert into table translations ... insert what? insert into translations default values; > The other way to do this that I see is to lose the link table > translations_to_phrases, and then make translations > > create table translations ( > id serial primary key, > phrases integer[] > ); > > but it seems that I can no longer make postgre aware that the integers > in translations(phrases) are references. I wouldn't use an array. I think arrays are best for data that can be considered one chunk of stuff by postgresql, with the arrayness of that chunk of stuff only mattering to the application.
