The example given in create domain seems to be broken. ISTM it requires some 
extra escaping to be usable (at least in my goings on today it sure was, and 
I the entries in pg_constraint sure seem to indicate this as well).  I 
suggest that the examples should be updated as per the following patch. 

Oh.. and Andrew @ Supernews had nothing to do with this ;-)

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Index: create_domain.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/create_domain.sgml,v
retrieving revision 1.20
diff -c -r1.20 create_domain.sgml
*** create_domain.sgml	4 Jan 2005 00:39:53 -0000	1.20
--- create_domain.sgml	30 Apr 2005 22:06:33 -0000
***************
*** 167,174 ****
  <programlisting>
  CREATE DOMAIN us_postal_code AS TEXT
  CHECK(
!    VALUE ~ '^\d{5}$'
! OR VALUE ~ '^\d{5}-\d{4}$'
  );
  
  CREATE TABLE us_snail_addy (
--- 167,174 ----
  <programlisting>
  CREATE DOMAIN us_postal_code AS TEXT
  CHECK(
!    VALUE ~ '^\\d{5}$'
! OR VALUE ~ '^\\d{5}-\\d{4}$'
  );
  
  CREATE TABLE us_snail_addy (
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to