gnumed-bugs
[Top][All Lists]
Advanced

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

[Gnumed-bugs] missing clause WHERE in Happy Birthday list (1 week back a


From: Busser, Jim
Subject: [Gnumed-bugs] missing clause WHERE in Happy Birthday list (1 week back and forth from today)
Date: Wed, 27 Nov 2013 23:15:49 +0000

What currently appears in my stored queries (Reports plugin) is as follows

-- ============================================
select
        to_char(p.dob, 'DD.TMMonth') as birthday,
        extract(year from age(dob) - '10 days'::interval) as age,
        p.lastnames || ', ' || p.firstnames as name,
        p.preferred as preferred_name,
        p.pk_identity as pk_patient
from
        dem.v_basic_person p
order by
        name
-- ============================================

might have undergone accidental modification at my end however I never use it.

If OTOH the "stock" version is defective, it could do with fixing in a fixup.

-- Jim





reply via email to

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