Paul J Stevens wrote:
Uwe Kiewel wrote:
Dropping the lower function would require additional precautions in the
code.
I know. As I described in my initial posting, in that case you have to
do the lower function in the program code before you pass the parameters
to the query.
You can't be 100% sure the data in the column is fully lower-cased. In
that case lowercasing before building the query won't do, unless you
accept the possibility of false bounces.
Why not? We discuss about "alias" column, right? So, the column is
filled by dbmail-user utility. Might it be enough, to let dbmail-user
utility to do the lower function before inserting "alias" values?
In my case "deliver_to" column contains only numbers, corresponding to
the "user_idnr" values in the dbmail_users table.
I am not sure, maybe there is also the possibility to put a real email
address into "deliver_to" for external mail forwarding. If so,
dbmail-users has also to manage the lower function for "deliver_to" values.
Uwe
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
