Thanks, I didn't think of trying that. It seems to work.
-Peter
On Sun, Sep 15, 2002 at 06:55:08PM +0100, Bill Michell wrote:
I haven't tried it, but surely locallowercase would do exactly this?
-----Original Message-----
From: cour...@lists.sourceforge.net
[mailto:cour...@lists.sourceforge.net]On Behalf
Of Peter C.
Norton
Sent: 15 September 2002 16:58
To: cour...@lists.sourceforge.net
Subject: Re: [courier-users] Re: using lower in username queries
On Sun, Sep 15, 2002 at 10:50:00AM -0400, Sam Varshavchik wrote:
Peter C. Norton writes:
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.
PGSQL_LOGIN_FIELD lower(id)
Sam,
I think that creates a query that says "lowercase the field in the
database that contains the loginid, and then compare it to the string
that the sending mta/user has entered as a recipient". That is
different then what I'm looking for, which is "lowercase the recipient
string that is provided by the sending mta or user, and compare that
lowercased string to the PGSQL_LOGIN_FIELD in the database".
If there isn't a way to do that, I think it'd be a nice feature to
add. I'll work on it if you like.
https://lists.sourceforge.net/lists/listinfo/courier-users
7 messages in net.sourceforge.lists.courier-usersRe: [courier-users] Re: using lower i...
