Re: Postgre RAISE NOTICE and PHP

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(at)stonehenge(dot)com> wrote:
> >>>>>> "Clemens" == Clemens Schwaighofer <clemens_schwaighofer(at)e-gra(dot)co(dot)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}(at)[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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

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