Select all invalid e-mail addresses

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Select all invalid e-mail addresses
Date: 2005-10-19 18:12:16
Message-ID: dj6306$2n8f$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bart Grantham 2005-10-19 18:18:34 Re: Postgresql Mention-- Logicworks' LogicOps Management
Previous Message Guy Rouillier 2005-10-19 17:56:29 Re: [pgsql-advocacy] Oracle buys Innobase