[Gnumed-devel] gmI18N.sql - just an example

[Karsten Hilbert]

Compare this. We went from

-- =============================================
--create view v_i18n_doc_type as
--  select
--      doc_type.id,
--      i18n_translations.trans as name
--  from
--      doc_type,
--      i18n_translations
--  where (
--      i18n_translations.lang = (select lang from i18n_curr_lang where owner = 
CURRENT_USER::varchar)
--  ) and (
--      doc_type.name = i18n_translations.orig
--  )
--  ;
-- =============================================

to

-- =============================================
create view v_i18n_doc_type as
    select
        doc_type.id,
        _(doc_type.name)
    from
        doc_type
    ;
-- =============================================

This sure looks cleaner to me.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346