Michael Monnerie wrote:
> I have this log:
> dbpgsql.c,db_query(+279): [SELECT deliver_to FROM dbmail_aliases WHERE
> lower(alias) = lower('[EMAIL PROTECTED]') AND lower(alias) <>
> lower(deliver_to)]
>
> couldn't you write ....'AND alias <> deliver_to'? I mean, skip
> the "lower()' twice? Just force entries in that table to be lower()
> already. I heard in some RFC they say that upper/lowercase should be a
> difference, but I never saw that in live use.
That's incorrect. Email addresses are case-insensitive. And no, we
cannot be sure the values entered are indeed lower-case, unless we setup
a trigger.
Postgres allows you to 'create index lower(column)' which will resolve
the performance issues here.
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
