gnumed-devel
[Top][All Lists]
Advanced

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

[Gnumed-devel] user contributed report


From: GNUmed Report Generator
Subject: [Gnumed-devel] user contributed report
Date: Thu, 23 Jul 2009 19:03:22 -0400

This is a report definition contributed by a GNUmed user:

#--------------------------------------

find persons by postal code (lower case)

select number, street, dem.v_basic_person.lastnames, 
dem.v_basic_person.preferred, dem.v_basic_person.firstnames, suburb, urb, 
postcode, pk_identity as pk_patient
from
        dem.v_basic_person
                inner join
        dem.v_pat_addresses
                using (pk_identity)
where
        LOWER(dem.v_pat_addresses.postcode) = 
'inputDesiredPostalCodeHereInLowerCase'
order by
        street, number

#--------------------------------------

The GNUmed client.

reply via email to

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