Re: [Gnumed-devel] freshly-created patients do not populate the 'recent searches' dropdown

[Karsten Hilbert]

On Tue, Dec 27, 2011 at 08:01:57PM +0000, Jim Busser wrote:

> >>    where c_e.modified_when > now() - interval '7 days'
> >> 
> >>    and c_e.modified_when > now() - interval '7 days'
> > 
> > What is the intent of the duplicate constraint ?
> 
> It is a single constraint, intended to be applied (added) once to each of the 
> two queries that I had provided.
> 
> The reason that it appears twice above is because in one case, my original 
> query contained no where clause (hence the 'where' is included above), 
> whereas in the other case a where clause had already been part of the query 
> and I only intended above that the 'and …' be added.

Ah, I see.

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