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