Re: table has a many to many relationship with itself ... ?

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.