I wonder if you could make an SQL type that used text[] as its storage format but had an output function that displayed the correct text for the "current locale". Where "current locale" could be something you set by calling a function at the beginning of the transaction.
Do pg_dump and all the important things use the send/receive functions not the input/output functions? so even though this output function loses information it wouldn't cause serious problems? You would still need a way to retrieve all the languages for the cases like administrative interfaces for updating the information. I'm not entirely convinced this would be any better than the alternative of retrieving all of them by default and having a function to retrieve only the correct language. -- greg ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
