On Tue, Aug 23, 2011 at 4:53 PM, Hitoshi Harada <umi.tanuki@gmail.com> wrote:
> In the CREATE DOMAIN reference page of the current HEAD, it says
>
> ---
> CREATE DOMAIN us_postal_code AS TEXT
> CHECK(
> VALUE ~ '^\\d{5}$'
> OR VALUE ~ '^\\d{5}-\\d{4}$'
> );
> ---
>
> but I believe it should conform the standard string style now that the
> default is standard_conforming_strings = on.
I agree. Done.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company