git.postgresql.org Git - users/rhaas/postgres.git/commit

projects / users / rhaas / postgres.git / commit

author	Tom Lane <tgl@sss.pgh.pa.us>
	Sat, 14 Feb 2004 20:16:18 +0000 (20:16 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Sat, 14 Feb 2004 20:16:18 +0000 (20:16 +0000)
commit	a9e08392dd6fc6d7d1122296bf5525fbbd61ad0d
tree	7fa85628cd2a11bcfd209c31b9b4a89b01bff1b0	tree
parent	2e5fe483a326072415dd7e9100a25670d3edd03e	commit \| diff

Create crosstype comparison operators for date vs. timestamp and date
vs. timestamptz. This allows use of indexes for expressions like
datecol >= date 'today' - interval '1 month'
which were formerly not indexable without casting the righthand side
down from timestamp to date.

Robert Haas's development tree.

RSS Atom

src/backend/utils/adt/date.c		diff \| blob \| blame \| history
src/backend/utils/adt/timestamp.c		diff \| blob \| blame \| history
src/include/catalog/catversion.h		diff \| blob \| blame \| history
src/include/catalog/pg_amop.h		diff \| blob \| blame \| history
src/include/catalog/pg_amproc.h		diff \| blob \| blame \| history
src/include/catalog/pg_operator.h		diff \| blob \| blame \| history
src/include/catalog/pg_proc.h		diff \| blob \| blame \| history
src/include/utils/date.h		diff \| blob \| blame \| history
src/include/utils/timestamp.h		diff \| blob \| blame \| history