gnumed-devel
[Top][All Lists]
Advanced

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

Re: [Gnumed-devel] Maintaining patient demographics


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Maintaining patient demographics
Date: Mon, 29 Aug 2011 22:14:31 +0200
User-agent: Mutt/1.5.21 (2010-09-15)

On Sun, Aug 28, 2011 at 08:47:15PM -0700, Jim Busser wrote:

> > One option would be
> > 
> >     where dem.v_person_comms.url LIKE '%1%2%3%4%5%6%7%8%9%0'
> 
> A better help to future less-technical GNUmed users might be to improve the 
> pre-loaded query example text in
> 
>       find patients by phone/fax/...
> 
> to
> 
>       where dem.v_person_comms.url LIKE 'put the URL/number here, using % as 
> a wildcard for example %123%456%7890%'

The improvement as such is good but one can't use % as a
generic wildcard:

        
http://www.postgresql.org/docs/9.0/static/functions-matching.html#FUNCTIONS-LIKE

I suppose the regexp_replace() approach is much more powerful.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346



reply via email to

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