Re: Problem with Create Domain example - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: Problem with Create Domain example
Date
Msg-id 20050501011459.GD24028@dcc.uchile.cl
Whole thread Raw
In response to Problem with Create Domain example  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: Problem with Create Domain example  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-patches
On Sat, Apr 30, 2005 at 06:12:27PM -0400, Robert Treat wrote:

> --- 167,174 ----
>   <programlisting>
>   CREATE DOMAIN us_postal_code AS TEXT
>   CHECK(
> !    VALUE ~ '^\\d{5}$'
> ! OR VALUE ~ '^\\d{5}-\\d{4}$'
>   );

Huh, why not

VALUE ~ '^\\d{5}(-\\d{4})?$'

?

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Cuando no hay humildad las personas se degradan" (A. Christie)

pgsql-patches by date:

Previous
From: Robert Treat
Date:
Subject: Problem with Create Domain example
Next
From: Robert Treat
Date:
Subject: Re: Problem with Create Domain example