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

From Scott Marlowe
Subject Re: Postgre RAISE NOTICE and PHP
Date
Msg-id dcc563d10908191057m7cfb8322rfff93646184ae503@mail.gmail.com
Whole thread Raw
In response to Re: Postgre RAISE NOTICE and PHP  (merlyn@stonehenge.com (Randal L. Schwartz))
Responses Re: Postgre RAISE NOTICE and PHP
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: Requesting help on PostgreSQL Replication
Next
From: Tom Lane
Date:
Subject: Re: pg_restore returns always error if backup is greater than 2 GB