[GENERAL] table has a many to many relationship with itself ... ?

2006-06-15 Thread Daniel McBrearty
nteger[] ); but it seems that I can no longer make postgre aware that the integers in translations(phrases) are references. What is the best solution? Thanks Daniel -- Daniel McBrearty email : danielmcbrearty at gmail.com www.engoi.com : the multi - language vocab trai

Re: [GENERAL] table has many to many relationship with itself - how

2006-06-14 Thread Daniel McBrearty
her 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 ---(end of broadcast)--- TIP 9:

[GENERAL] table has many to many relationship with itself - how to implement?

2006-06-14 Thread Daniel McBrearty
[] ); but it seems that I can no longer make postgre aware that the integers in translations(phrases) are references. What is the best solution? Thanks Daniel -- Daniel McBrearty email : danielmcbrearty at gmail.com www.engoi.com : the multi - language vocab trai

[GENERAL] advice on schema for multilingual text

2006-04-09 Thread Daniel McBrearty
HiI have a website that has multilingual text stored in the database. Currently I just have a flat table (lets called it "translations"), one row per text item, one column per language. This works OK, for now, but I am looking at a redesign. Mostly I want to keep information about the languages in