Re: Where can I find detail information about constraint ? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Where can I find detail information about constraint ?
Date
Msg-id 4AB9F848.6020006@iol.ie
Whole thread Raw
In response to Where can I find detail information about constraint ?  (纪晓曦 <sheepjxx@gmail.com>)
List 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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Re: PL/PG SQL: select count(*) into from where - does not compute the where cond - returns always total count
Next
From: Peter Geoghegan
Date:
Subject: multiple calls to dblink_connect from within pl/pgSQL function exhaust connection limit