Re: Force a merge join?

At 12:24 AM 5/16/02 -0400, Tom Lane wrote:
>Improving this is on the TODO list ...but in the meantime I wonder why
>you couldn't force an email-address column to lower case when you store
>it, so as to simplify the join problem. The RFCs nominally allow the
>local-part of an email address to be case sensitive, but in practice
>there is no one who really expects a case-sensitive email address to
>work.

Could use an extra column - so you can keep one column for display and one
for matching/searches.

So it would be easier to treat the following addresses as identical without
having to do it all in an SQL function:
Doug Fields <dfields-pg-general(at)pexicom(dot)com>
Doug Fields <dfields-pg-general(at)pexicom(dot)com(dot)>
(D Fields ) dfields-pg-general(at)PEXICOM(dot)COM

Cheerio,
Link.