Re: [Gnumed-devel] user contributed report

[Karsten Hilbert]

On Thu, Jul 23, 2009 at 06:59:15PM -0400, GNUmed Report Generator wrote:
> Subject: [Gnumed-devel] user contributed report
> 
> 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.


Added to the database.

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