arta...@comcast.net (Scott Bailey) writes: > Disk format - A period can be represented as [closed-closed], > (open-open), [closed-open) or (open-closed] intervals. Right now we > convert these to the most common form, closed-open and store as two > timestamptz's.
I mentioned this at the 2009 PGCon, and it was pointed out to me that PostgreSQL already has geometric types which already offer many of the semantics and operators that are likely to be desired. <http://www.postgresql.org/docs/8.4/static/functions-geometry.html> If direct analogy may be applied so that portions of the functionality are drawn from previously-accepted geometric contributions, it's likely to be a bit easier to get this into 8.5 (or so!) FYI, I *love* the idea of having the temporal types and operators. I'm a lot less certain about the merits of PK/FK constraints - it is a lot less obvious what forms of constraints will be able to be applied to particular applications. -- "I really only meant to point out how nice InterOp was for someone who doesn't have the weight of the Pentagon behind him. I really don't imagine that the Air Force will ever be able to operate like a small, competitive enterprise like GM or IBM." -- Kent England -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
