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.
