Re: Design question, Does postgres provide a simpler solution than the obvious?

On Monday 07 Oct 2002 11:49 pm, Greg Stark wrote:
> I guess my ideal solution would allow me to issue an insert or update on
> the original table with some sort of associative array data structure as
> the value for the string field. The appropriate work would all get done
> automatically. Then selects would either return the associative array or
> perhaps even implement the entire logic for looking up the correct string
> to display.

Just to clarify, assuming the preferred language is French and the default
English, you want something like:

 id lang phrase
 73   FR bonjour
 73   EN hello
 74   EN goodbye

You then want to be able to do:

SELECT phrase FROM foo WHERE id=73 or 74;
 phrase
=======
bonjour
goodbye

Is this the sort of thing you're after?

--
  Richard Huxton