Re: Domain Check Constraints

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Domain Check Constraints
Date: 2002-11-15 02:49:30
Message-ID: 200211150249.gAF2nVv23204@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


Patch applied. Thanks.

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

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-11-15 02:52:18 Re: Domain Check Constraints
Previous Message Neil Conway 2002-11-14 23:32:57 standardize on "canceled"