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 (<[EMAIL PROTECTED]>)
"Cuando no hay humildad las personas se degradan" (A. Christie)

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to