Thanks Joel... that did the trick (even better than I had asked for).
Forgive my ignorance, but it your solution a regular expression?
Can anyone suggest a good source where I can read up on these (regex's) in relation to postgresql?
On Sun, 12 May 2002, Joel Burton wrote:
> > One column in my table contains email addresses - I want to check
> > that any value entered contains a '@'. How do I create a
> > CONSTRAINT or CHECK to ensure this when creating the table?
> create table em (
> em text constraint is_email check (em like '%(at)%(dot)%')
> will work fine, assuming that this check (something @ something . something)
> is acceptable in your context as "looks like an email address"
> - J.
> Joel BURTON | joel(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
> Knowledge Management & Technology Consultant
JUSTATEST Art Online
In response to
pgsql-novice by date
|Next:||From: Brian Schroeder||Date: 2002-05-12 23:30:19|
|Subject: Re: Relation does not exist|
|Previous:||From: Joel Burton||Date: 2002-05-12 19:50:50|
|Subject: Re: newbie: Column CHECK(col contains '@') ?|