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

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql-server/src backend/utils/adt/date.c back ...
Date
Msg-id 20040214201618.98FE5D1D501@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
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.


pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql-server/src/backend/optimizer/plan Tag: R ...
Next
From: neilc@svr1.postgresql.org (Neil Conway)
Date:
Subject: pgsql-server/doc/src/sgml/ref create_cast.sgml