| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | 纪晓曦 <sheepjxx(at)gmail(dot)com> |
| Cc: | Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Where can I find detail information about constraint ? |
| Date: | 2009-09-23 10:28:24 |
| Message-ID: | 4AB9F848.6020006@iol.ie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 23/09/2009 11:23, 纪晓曦 wrote:
> I want detail usage introduction about constraint,such as how to
> constrain a string to be exactly 4 character and start with 'z'.
> Where can I find the reference of CHECK? detail usage.
Try the documentation, presumably under CREATE TABLE:
http://www.postgresql.org/docs
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2009-09-23 11:11:28 | multiple calls to dblink_connect from within pl/pgSQL function exhaust connection limit |
| Previous Message | A. Kretschmer | 2009-09-23 10:25:15 | Re: Re: PL/PG SQL: select count(*) into <var> from <ANY VIEW> where <cond> - does not compute the where cond - returns always total count |