Re: newbie: Column CHECK(col contains '@') ? - Mailing list pgsql-novice

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?

thanks again,
/j-p.


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 '%@%.%')
> );
>
> 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@joelburton.com | joelburton.com | aim: wjoelburton
> Knowledge Management & Technology Consultant
>


-----------------------
 JUSTATEST Art Online
  www.justatest.com