Re: PostgreSQL 9.2 tstzrange null/infinity CONSTRAINT CHECK - Mailing list pgsql-sql

On 2013-10-16 Wed 13:50 PM |, Craig R. Skinner wrote:
> I'd like to limit a 9.2 tstzrange to valid dates at both ends.
> No NULLs nor 'infinity'.
> 
> CREATE TABLE bill
> (
>   id serial NOT NULL,
>   created_at timestamp with time zone NOT NULL DEFAULT now(),
>   period tstzrange NOT NULL,
>   -- other columns
>   CONSTRAINT bill_pk PRIMARY KEY (id),

This works:
 CONSTRAINT bill_period_not_null_nor_infinity_ck CHECK (   lower(period) IS NOT NULL AND   upper(period) IS NOT NULL
AND  (lower(period) > '-infinity') AND   (upper(period) < 'infinity') )
 


Cheers,
-- 
Craig Skinner | http://twitter.com/Craig_Skinner | http://linkd.in/yGqkv7