gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Updating dem listings for Brazil
Date: Wed, 16 Nov 2011 19:27:12 +0100

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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]