thanks Susan for your idea.
I thought that was it for a moment, then I saw a problem (I think) -
it works, but gets quite inefficient.
when you have 2 phrases which are a translation, that is just one entry
when you have 3, that is 3
4 => 6
and so on.
In practice we might have 15, 20 languages in a translation. It is
unlimited many-to-many.
So the problem is a bit to do this while keeping the solution efficient.
I am almost sold on just using
create table translaton (
id serial,
phrases integer[]
);
but afaik there is no way to tell pg that the array contains refs to
another table. I could still live with this though, if noone has a
better way.
regards
Daniel
--
Daniel McBrearty
email : danielmcbrearty at gmail.com
www.engoi.com : the multi - language vocab trainer
BTW : 0873928131
