Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: newbie: Column CHECK(col contains '@') ?
Date
Msg-id web-1457726@davinci.ethosmedia.com
Whole thread Raw
In response to newbie: Column CHECK(col contains '@') ?  (john-paul delaney <jp@justatest.com>)
List pgsql-novice
Tree view 
JP,

> 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?

Here's the online documentation.  It's very good, you should give it a
try!

http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/sql-createtable.html

-Josh Berkus

pgsql-novice by date:

Previous
From: john-paul delaney
Date:
Subject: newbie: Column CHECK(col contains '@') ?
Next
From: "G"
Date:
Subject: Selecting random rows using weights