Re: Email address column verification foraddress list - Mailing list pgsql-general

From merlyn@stonehenge.com (Randal L. Schwartz)
Subject Re: Email address column verification foraddress list
Date
Msg-id 864ojfqzkl.fsf@red.stonehenge.com
Whole thread Raw
In response to Re: Email address column verification foraddress list  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: Email address column verification foraddresslist  ("Andrus" <kobruleht2@hot.ee>)
Re: Email address column verification foraddress list  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
List pgsql-general
>>>>> "Andrus" == Andrus  <kobruleht2@hot.ee> writes:

Andrus> This is existing database deployed to many sites and used by many programs.
Andrus> Re-factoring db and software to add this minor feature seems to be not
Andrus> reasonable. For 99% of cases field contains only single address.

So for most applications written against this database, they're probably
assuming only one email address in this column.

And then you confuse the issue by putting two or more comma-separated
addresses, which are not universally usable when a single address
is provided.

I sense this code will end up on thedailywtf.com[1] when you leave
and your successor discovers what you insanely tried to do.

[1] which should be mandatory reading for *all* devs, with the goal
    of "never let my code end up here"

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc.
See http://methodsandmessages.vox.com/ for Smalltalk and Seaside discussion

pgsql-general by date:

Previous
From: "Plugge, Joe R."
Date:
Subject: Re: Query is stuck
Next
From: "Andrus"
Date:
Subject: Re: Email address column verification foraddresslist