Re: SQL:2011 PERIODS vs Postgres Ranges? - Mailing list pgsql-hackers

The patch does not work.

postgres=# CREATE TABLE foo (id int,r int4range, valid_at tsrange, CONSTRAINT bar_pk PRIMARY KEY (r, valid_at WITHOUT
OVERLAPS));
CREATE TABLE
postgres=# CREATE TABLE bar (id int,r int4range, valid_at tsrange, CONSTRAINT bar_fk FOREIGN KEY (r, PERIOD valid_at)
REFERENCESfoo);
 
ERROR:  cache lookup failed for type 0

The new status of this patch is: Waiting on Author