Re: Problem with Create Domain example

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Problem with Create Domain example
Date: 2005-05-01 01:14:59
Message-ID: 20050501011459.GD24028@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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[(at)]dcc(dot)uchile(dot)cl>)
"Cuando no hay humildad las personas se degradan" (A. Christie)

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Robert Treat 2005-05-01 02:08:32 Re: Problem with Create Domain example
Previous Message Robert Treat 2005-04-30 22:12:27 Problem with Create Domain example