Re: Select all invalid e-mail addresses

From: "Guy Rouillier" <guyr(at)masergy(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Select all invalid e-mail addresses
Date: 2005-10-19 19:04:55
Message-ID: CC1CF380F4D70844B01D45982E671B239E8BE9@mtxexch01.add0.masergy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrus wrote:
> I have a database of e-mail addresses.
>
> I want to select the email addresses which are not valid:
>
> do not contain exactly one @ character,
> contain ; > < " ' , characters or spaces etc.
>
> What is the WHERE clause for this ?

Please see a long, detailed thread in the archives titled "Email
Verification Regular Expression" on Sept 7, 2005.

--
Guy Rouillier

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-10-19 19:18:49 Re: Select all invalid e-mail addresses
Previous Message Edmund 2005-10-19 18:57:44 Re: Select all invalid e-mail addresses