Postgres Pro
Downloads
Home   >   mailing lists

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

From john-paul delaney
Subject newbie: Column CHECK(col contains '@') ?
Date
Msg-id Pine.LNX.4.21.0205121705340.1265-100000@justatest.com
Whole thread Raw
Responses Re: newbie: Column CHECK(col contains '@') ?  ("Josh Berkus" <josh@agliodbs.com>)
Re: newbie: Column CHECK(col contains '@') ?  ("Joel Burton" <joel@joelburton.com>)
List pgsql-novice
Tree view 
Hello list...

One column in my table contains email addresses - I want to check that any value entered contains a '@'.  How do I
createa CONSTRAINT or CHECK to ensure this when creating the table? 

Thanks for any help.
/j-p.


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

pgsql-novice by date:

Previous
From: Vijay Deval
Date:
Subject: Re: What are schemas?
Next
From: "Josh Berkus"
Date:
Subject: Re: newbie: Column CHECK(col contains '@') ?