pgsql-server/src backend/utils/adt/date.c back ...

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/src backend/utils/adt/date.c back ...
Date: 2004-02-14 20:16:18
Message-ID: 20040214201618.98FE5D1D501@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl(at)svr1(dot)postgresql(dot)org 04/02/14 16:16:18

Modified files:
src/backend/utils/adt: date.c timestamp.c
src/include/catalog: catversion.h pg_amop.h pg_amproc.h
pg_operator.h pg_proc.h
src/include/utils: date.h timestamp.h

Log message:
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.

Browse pgsql-committers by date

  From Date Subject
Next Message Neil Conway 2004-02-15 06:27:37 pgsql-server/doc/src/sgml/ref create_cast.sgml
Previous Message Tom Lane 2004-02-13 22:26:43 pgsql-server/src/backend/optimizer/plan Tag: R ...