[Top][All Lists]
[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 18:59:15 -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.