Re: [Gnumed-devel] Country zones and i18n

[Karsten Hilbert]

On Wed, Nov 16, 2011 at 11:02:56PM +0000, Jim Busser wrote:

> I agree it is possible to create a row in
> 
>       dem.street
> 
> in which the id_urb is a value referencing the dem.urb row
> for the Brazilian city 'Corumba' meaning that yes, it is
> technically possible to create such a row even if the table
> i18n.translations were empty. The problem is how, using a
> SELECT, to figure out the referent record in dem.urb where
> that urb's name (in dem.urb) is 'Corumba' whereas what we
> have in the source table is 'Corumbá'

If I understand correctly what you are asking for there's
two ways:

        - unaccent('Corumbá')
        - untranslate('Corumbá')

both of which do not yet exist as is.

        - map using a staging table created
          from what the source file provided

which can be created by the data pack.

What I don't yet comprehend is - exactly when do you need to

        using a SELECT, to figure out the referent record in
        dem.urb where that urb's name (in dem.urb) is 'Corumba'

?

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346