On Tue, Oct 11, 2011 at 08:59:01PM +0200, jm130794 wrote: > I use EmailAddress to store my email. Only two users don't have > email : RT_System and Nobody. > > rt3=# select Name,EmailAddress,gecos from users where Name like 'jmcarica'; > name | emailaddress | gecos > ----------+-------------------------------------+------------ > jmcarica | [email protected] | jmcaricand
I suggest you do like '%jmcarica%' so it does the search you intended. I suggest you also compare email addresses. You didn't provide any of your mappings for your 3 canonicalization lookups, so unfortunately we're just guessing back and forth at what happens, but at least one of yours appeared to have a Gecos mismatch. -kevin
pgpkTxxDfPW8j.pgp
Description: PGP signature
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Barcelona, Spain November 28 & 29, 2011
