Re: [Gnumed-devel] Updating dem listings for Brazil

[Karsten Hilbert]

then (while harmless) it is unnecessary -- at the point of adding missing 
records to the the dem.state table -- to have to re-issue the i18n as

    SELECT DISTINCT ON (UPPER(s_s.code)) UPPER(s_s.code),  i18n.i18n(s_s.name), 
s_s.country
    FROM staging.state s_s ...

and I can just do

    SELECT DISTINCT ON (UPPER(s_s.code)) UPPER(s_s.code),  i18n.i18n(s_s.name), 
s_s.country
    FROM staging.state s_s ...


-> yes (you meant to leave out the i18n.i18n(), right ?)


    SELECT DISTINCT ON (UPPER(s_s.code)) UPPER(s_s.code),  s_s.name, s_s.country
    FROM staging.state s_s ...


Karsten
-- 
NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!               
Jetzt informieren: http://www.gmx.net/de/go/freephone