Re: newbie: Column CHECK(col contains '@') ?

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 '%(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
www.justatest.com