Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-20 Thread Clemens Schwaighofer
On Thu, Aug 20, 2009 at 21:52, Jasen Betts wrote: > On 2009-08-19, Clemens Schwaighofer wrote: >> On Wed, Aug 19, 2009 at 02:11, Randal L. Schwartz >> wrote: "Andre" == Andre Lopes writes: >>> >>> Andre> I'm developing a function with some checks, for example... to check >>> if the >>>

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-20 Thread Sam Mason
On Thu, Aug 20, 2009 at 01:03:47PM +, Jasen Betts wrote: > On 2009-08-20, Randal L. Schwartz wrote: > > Exactly! If you don't want to use the 950-character regex, DON'T DO > > ANYTHING AT ALL. Far simpler. > > Or do an MX lookup on the domain part (or a partial attempt to route > mail*) bef

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-20 Thread Jasen Betts
On 2009-08-20, Randal L. Schwartz wrote: >> "Clemens" == Clemens Schwaighofer >> writes: > >Clemens> I am not going to defend any regex here, but in my opinion it helps on >Clemens> what I want to see in email addresses. >Clemens> Yes it fails on mobile, but I have not yet seen one. > >

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-20 Thread Jasen Betts
On 2009-08-19, Clemens Schwaighofer wrote: > On Wed, Aug 19, 2009 at 02:11, Randal L. Schwartz > wrote: >>> "Andre" == Andre Lopes writes: >> >> Andre> I'm developing a function with some checks, for example... to check >> if the >> Andre> e-mail is valid or not. >> >> How are you hoping to

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-19 Thread Clemens Schwaighofer
On 08/19/2009 11:41 PM, Randal L. Schwartz wrote: >> "Clemens" == Clemens Schwaighofer >> 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!#$%&'*+-\/=?^_`{

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-19 Thread Randal L. Schwartz
> "Clemens" == Clemens Schwaighofer > writes: Clemens> I am not going to defend any regex here, but in my opinion it helps on Clemens> what I want to see in email addresses. Clemens> Yes it fails on mobile, but I have not yet seen one. And that's the problem. You get near-sighted if yo

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-19 Thread David Fetter
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 wrote: > >> "Clemens" == Clemens Schwaighofer > >> writes: > > > > Clemens> Just in my opinion, this regex is completely too large. For basic > > Clemens> validating some

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-19 Thread Scott Marlowe
On Wed, Aug 19, 2009 at 8:41 AM, Randal L. Schwartz wrote: >> "Clemens" == Clemens Schwaighofer >> 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!#$%&'*+-

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-19 Thread Clemens Schwaighofer
On Wed, Aug 19, 2009 at 02:11, Randal L. Schwartz wrote: >> "Andre" == Andre Lopes writes: > > Andre> I'm developing a function with some checks, for example... to check if > the > Andre> e-mail is valid or not. > > How are you hoping to do this?  The regex to validate an email > address synt

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-19 Thread Randal L. Schwartz
> "Clemens" == Clemens Schwaighofer > 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,6...@[a-za-z0-9-]+(\.[a-zA-Z0-9-]{1,})*\.([a-zA-Z]{2,

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-19 Thread Michael Glaesemann
On Aug 18, 2009, at 16:45 , Scott Marlowe wrote: On Tue, Aug 18, 2009 at 10:57 AM, Andre Lopes wrote: I need to know if it is possible to show this RAISE NOTICE when I run this function from PHP. http://www.php.net/manual/en/function.pg-last-notice.php Thanks, Scott. Is there an equiva

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-18 Thread Adam Rich
Andre, See this PHP page: http://www.php.net/manual/en/function.pg-last-notice.php Andre Lopes wrote: Hi, I'm developing a function with some checks, for example... to check if the e-mail is valid or not. If the e-mail is not valid I put a line with RAISE NOTICE 'E-mail not valid'. I n

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-18 Thread Scott Marlowe
On Tue, Aug 18, 2009 at 10:57 AM, Andre Lopes wrote: > Hi, > > I'm developing a function with some checks, for example... to check if the > e-mail is valid or not. > > If the e-mail is not valid I put a line with RAISE NOTICE 'E-mail not > valid'. > > I need to know if it is possible to show this R

Re: [GENERAL] Postgre RAISE NOTICE and PHP

2009-08-18 Thread Randal L. Schwartz
> "Andre" == Andre Lopes writes: Andre> I'm developing a function with some checks, for example... to check if the Andre> e-mail is valid or not. How are you hoping to do this? The regex to validate an email address syntactically is pretty large: http://ex-parrot.com/~pdw/Mail-RFC822-Ad

[GENERAL] Postgre RAISE NOTICE and PHP

2009-08-18 Thread Andre Lopes
Hi, I'm developing a function with some checks, for example... to check if the e-mail is valid or not. If the e-mail is not valid I put a line with RAISE NOTICE 'E-mail not valid'. I need to know if it is possible to show this RAISE NOTICE when I run this function from PHP. Best Regards, André