7 messages in net.sourceforge.lists.courier-usersRe: [courier-users] Re: using lower i...
FromSent OnAttachments
Peter C. NortonSep 14, 2002 1:15 am 
Sam VarshavchikSep 14, 2002 7:08 am 
Peter C. NortonSep 15, 2002 1:33 am 
Sam VarshavchikSep 15, 2002 7:50 am 
Peter C. NortonSep 15, 2002 8:58 am 
Bill MichellSep 15, 2002 10:55 am 
Peter C. NortonSep 15, 2002 11:29 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [courier-users] Re: using lower in username queriesActions...
From:Peter C. Norton (spac@lenin.nu)
Date:Sep 15, 2002 1:33:40 am
List:net.sourceforge.lists.courier-users

On Sat, Sep 14, 2002 at 10:08:21AM -0400, Sam Varshavchik wrote:

Peter C. Norton writes:

What's the right way to get case insensetive matches in the database? Is there a way to tell courier that the query I want is, to use the example from the authpgsqlrc file:

SELECT PGSQL_UID_FIELD, PGSQL_GID_FIELD, ... WHERE id=lower('loginid')

Am I right in thinking that I'd have to edit authpgsqllib.c to get this behavior?

No. Using lower('loginid') instead of loginid in authmysqlrc should do the trick.

Sam,

I don't see where setting any info for the loginid is possible. It seems like I do the following:

SELECT PGSQL_UID_FIELD, PGSQL_GID_FIELD, ... WHERE lower(id)='loginid'

by setting

PGSQL_LOGIN_FIELD id

But I can't see how, besides altering the source I can set up my query to do a lower() on the loginid string.

Is there a way to do this?

-Peter

-- The 5 year plan: In five years we'll make up another plan. Or just re-use this one.