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

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: newbie: Column CHECK(col contains '@') ?
Date: 2002-05-12 17:30:45
Message-ID: web-1457726@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message john-paul delaney 2002-05-12 19:11:00 newbie: Column CHECK(col contains '@') ?
Previous Message Vijay Deval 2002-05-12 02:14:30 Re: What are schemas?