]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 2e5fe48) | patch
Create crosstype comparison operators for date vs. timestamp and date
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 14 Feb 2004 20:16:18 +0000 (20:16 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 14 Feb 2004 20:16:18 +0000 (20:16 +0000)
commita9e08392dd6fc6d7d1122296bf5525fbbd61ad0d
tree7fa85628cd2a11bcfd209c31b9b4a89b01bff1b0tree | snapshot
parent2e5fe483a326072415dd7e9100a25670d3edd03ecommit | 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.
src/backend/utils/adt/date.c diff | blob | history
src/backend/utils/adt/timestamp.c diff | blob | history
src/include/catalog/catversion.h diff | blob | history
src/include/catalog/pg_amop.h diff | blob | history
src/include/catalog/pg_amproc.h diff | blob | history
src/include/catalog/pg_operator.h diff | blob | history
src/include/catalog/pg_proc.h diff | blob | history
src/include/utils/date.h diff | blob | history
src/include/utils/timestamp.h diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.