On Wed, Aug 19, 2009 at 11:57:45AM -0600, Scott Marlowe wrote: > On Wed, Aug 19, 2009 at 8:41 AM, Randal L. > Schwartz<merlyn@xxxxxxxxxxxxxx> wrote: > >>>>>> "Clemens" == Clemens Schwaighofer <clemens_schwaighofer@xxxxxxxxxxx> writes: > > > > Clemens> Just in my opinion, this regex is completely too large. For basic > > Clemens> validating something like: > > Clemens> ^[A-Za-z0-9!#$%&'*+-\/=?^_`{|}~][A-Za-z0-9!#$%&'*+-\/=?^_`{|}~\.]{0,63}@[a-zA-Z0-9-]+(\.[a-zA-Z0-9-]{1,})*\.([a-zA-Z]{2,4}){1}$ > > Clemens> works very well > > > > Fails on ".mobile" TLD. Has a pointless {1} in it, which does > > absolutely nothing, providing that the creator of the regex was already > > missing a few clues. > > Remonds me of the saying that for every complex problem there is a > simple, elegant and incorrect solution. That's from H. L. Mencken. For every complex problem, there is an answer which is clear, simple, and wrong. Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general