Re: Postgre RAISE NOTICE and PHP - Mailing list pgsql-general

From David Fetter
Subject Re: Postgre RAISE NOTICE and PHP
Date
Msg-id 20090819220841.GB14330@fetter.org
Whole thread Raw
In response to Re: Postgre RAISE NOTICE and PHP  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
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@stonehenge.com> wrote:
> >>>>>> "Clemens" == Clemens Schwaighofer <clemens_schwaighofer@e-gra.co.jp> 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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stock Market Price Data & postgreSQL? HELLPPP Please
Next
From: Sanjay Arora
Date:
Subject: Re: Stock Market Price Data & postgreSQL? HELLPPP Please