Re: Domain Check Constraints - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Domain Check Constraints
Date
Msg-id 200211130223.gAD2NSF12240@candle.pha.pa.us
Whole thread Raw
In response to Domain Check Constraints  (Rod Taylor <rbt@rbt.ca>)
Responses Re: Domain Check Constraints  (Rod Taylor <rbt@rbt.ca>)
List pgsql-patches
Rod, do you want this added to the patches queue?

---------------------------------------------------------------------------

Rod Taylor wrote:
> Regress:
>     test geometry             ... FAILED
>
> But I'm using FreeBSD 4.7 RELEASE (PostgreSQL 7.4-devel)
>
>
> psql needs some additions to display the constraints, though I'm not
> sure what at the moment.
>
>
> Anyway, below is a sample:
>
> a=# create domain i as integer not null check (value > 15 or value = 5)
> check(value < 18);
> CREATE DOMAIN
> a=# select 7::i;
> ERROR:  Domain $1 constraint i failed
> a=# select 5::i;
>  i
> ---
>  5
> (1 row)
>
> a=# select 15::i;
> ERROR:  Domain $1 constraint i failed
> a=# select 20::i;
> ERROR:  Domain $2 constraint i failed
> a=# select 17::i;
>  i
> ----
>  17
> (1 row)
>
> a=#
>
> --
>   Rod Taylor

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: CLUSTER ALL patch
Next
From: Bruce Momjian
Date:
Subject: Re: minor SGML fix