Re: SQL:2011 application time - Mailing list pgsql-hackers

From jian he
Subject Re: SQL:2011 application time
Date
Msg-id CACJufxFxQH5NxD9UDvbcRCPtaSga+y0+Wwt54PA4KahLwhahOA@mail.gmail.com
Whole thread Raw
In response to Re: SQL:2011 application time  (jian he <jian.universality@gmail.com>)
Responses Re: SQL:2011 application time
List pgsql-hackers
hi. some trivial issue:

in src/backend/catalog/index.c
/* * System attributes are never null, so no need to check. */
if (attnum <= 0)

since you already checked attnum == 0
so here you can just attnum < 0?
-------------------------------------------------
ERROR:  column "valid_at" named in WITHOUT OVERLAPS is not a range type

IMHO, "named" is unnecessary.
-------------------------------------------------
doc/src/sgml/catalogs.sgml
pg_constraint adds another attribute (column): contemporal, seems no doc entry.

also the temporal in oxford definition is "relating to time", here we
can deal with range.
So maybe  "temporal" is not that accurate?



pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Add 'worker_type' to pg_stat_subscription
Next
From: Dean Rasheed
Date:
Subject: Re: Infinite Interval