Postgres Pro
Downloads
Home   >   mailing lists

Select all invalid e-mail addresses - Mailing list pgsql-general

From Andrus
Subject Select all invalid e-mail addresses
Date
Msg-id dj6306$2n8f$1@news.hub.org
Whole thread Raw
Responses Re: Select all invalid e-mail addresses  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: log_min_duration_statement oddity
Next
From: "Rafael Montoya"
Date:
Subject: Re: From oracle to postgresql...