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

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

From
tgl@svr1.postgresql.org (Tom Lane)
Date:
CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    tgl@svr1.postgresql.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.