Thread: Emal reg expression
i want to create a type for an email field but i'm not good with regx can some one help me?
Xai wrote: > i want to create a type for an email field but i'm not good with regx > can some one help me? Google for "email regex". Be warned - this is very complicated if you want to match *all* possible email addresses. -- Richard Huxton Archonet Ltd
On Wed, Oct 28, 2009 at 05:45:14AM -0700, Xai wrote:
> i want to create a type for an email field but i'm not good with regx
> can some one help me?
http://marc.info/?l=postgresql-general&m=112612299412819&w=2
2009/10/28 Richard Huxton <dev@archonet.com>: > Xai wrote: >> i want to create a type for an email field but i'm not good with regx >> can some one help me? > > Google for "email regex". Be warned - this is very complicated if you > want to match *all* possible email addresses. > Just send your users an email asking them to reply. If they do, it's obviously a valid address. Best regards, Will Temperley
On Wed, Oct 28, 2009 at 05:45:14AM -0700, Xai <rellonlawrence@gmail.com> wrote a message of 2 lines which said: > i want to create a type for an email field but i'm not good with regx Do not even try. http://stackoverflow.com/questions/201323/
William Temperley wrote: > 2009/10/28 Richard Huxton <dev@archonet.com>: >> Xai wrote: >>> i want to create a type for an email field but i'm not good with regx >>> can some one help me? >> Google for "email regex". Be warned - this is very complicated if you >> want to match *all* possible email addresses. >> > > Just send your users an email asking them to reply. If they do, it's > obviously a valid address. Depends on the content of the reply and your definition of "valid". I occasionally get emails from people intending to reach someone else. The address is "valid" to reach someone, but not "valid" to reach the intended party. Often I'll send a courtesy reply informing the sender that they have not reached the correct party and advising them to fix their address lists. -- Lew
On ons, 2009-10-28 at 05:45 -0700, Xai wrote: > i want to create a type for an email field but i'm not good with regx > can some one help me? I suggest that you make use of an already written module in some language such as Perl. See http://wiki.postgresql.org/wiki/Email_address_parsing for an example.