[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] user contributed report
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] user contributed report |
Date: |
Tue, 28 Jul 2009 15:32:52 +0200 |
User-agent: |
Mutt/1.5.20 (2009-06-14) |
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