[Top][All Lists]
[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