在 PostgreSQL 的这一天，25 年前

25年前的今天（PostgreSQL 7.0 开发周期），一个实现了对时间和日期支持进行大幅重构的补丁被提交。

commit 41f1f5b76ad8e177a2b19116cbf41384f93f3851
Author: Thomas G. Lockhart <lockhart@fourpalms.org>
Date:   Wed Feb 16 17:26:26 2000 +0000

    Implement "date/time grand unification".
     Transform datetime and timespan into timestamp and interval.
     Deprecate datetime and timespan, though translate to new types in gram.y.
     Transform all datetime and timespan catalog entries into new types.
     Make "INTERVAL" reserved word allowed as a column identifier in gram.y.
     Remove dt.h, dt.c files, and retarget datetime.h, datetime.c as utility
      routines for all date/time types.
     date.{h,c} now deals with date, time types.
     timestamp.{h,c} now deals with timestamp, interval types.
     nabstime.{h,c} now deals with abstime, reltime, tinterval types.
    Make NUMERIC a known native type for purposes of type coersion. Not tested.

25年前的今天（PostgreSQL 7.0 开发周期），一个提供布尔值B-tree索引支持的补丁被提交。

commit 7528fd2d52e74db25002a2b0d8c46bf373048838
Author: Bruce Momjian <bruce@momjian.us>
Date:   Thu Feb 10 19:51:52 2000 +0000

    Add btree indexing of boolean values
     Don Baccus

25年前的今天（PostgreSQL 7.0 开发周期），对 to_char() 函数的更新被提交。

commit 394af52795f6bb02ae26af2ddca6cec0f255ee33
Author: Bruce Momjian <bruce@momjian.us>
Date:   Tue Feb 8 15:57:01 2000 +0000

     I'm sending patch with new version of to_char numbers formatting.
    
     The PostgreSQL's to_char() is very compatible with Oracle's to_char
     now. I hope that to_char's 3000 rows of source is without bugs, but
     will good if anyone test it, for me it works very well :-)

25年前的今天（PostgreSQL 7.0 开发周期），一个补丁被提交，为 外键 功能添加了 MATCH <unspecified> 语法。

commit f59daf80f7f5a7dc553539b11972678cfd316b49
Author: Jan Wieck <JanWieck@Yahoo.com>
Date:   Mon Feb 7 17:50:38 2000 +0000

    Added complete MATCH  support contributed by Don Baccus.

25年前的今天（PostgreSQL 7.0 开发周期），一个补丁被提交，启用了对自引用 外键 约束的自动主键检测。

commit ad155605739705297be5429d920320d15c4facbe
Author: Jan Wieck <JanWieck@Yahoo.com>
Date:   Sat Feb 5 00:20:38 2000 +0000

    Enabling automatic primary key detection for self-referencing
    FOREIGN KEY constraint during CREATE TABLE. Tnx to Stephan.

25年前的今天（PostgreSQL 7.0 开发周期），一个补丁被提交，修复了一个长期存在的内存泄漏。

commit b64826a47d3dd81feccd40667b14f86c75e3d7b9
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date:   Fri Feb 4 03:16:03 2000 +0000

    Squash longstanding memory leak: when catcache.c copied a tuple into
    the cache context, it didn't bother to free the tuple that
    CatalogIndexFetchTuple had allocated in the transaction context.
    Do enough cache lookups in the same xact, and you start to notice...

25年前的今天（PostgreSQL 7.0 开发周期），PostgreSQL psqlODBC 驱动程序中添加了对 numeric 和 int8 数据类型的支持。

ommit 44035918bb3d00cf948270baeb989301faa7d867
Author: Byron Nikolaidis <byronn@insightdist.com>
Date:   Sun Jan 30 21:14:25 2000 +0000

    Added numeric and int8 types.
    Bug fix for LongVarBinary -- begin transaction

25年前的今天（PostgreSQL 7.0 开发周期），一个补丁被提交，使 EXPLAIN 在 Append、Group、Agg 和 Unique 节点上的结果更具说服力。

commit d24ef0d08fd278bbaa130329ff08de76f980b5aa
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date:   Thu Feb 3 06:12:19 2000 +0000

    Make EXPLAIN results for Append, Group, Agg, Unique nodes more plausible.
    Group and Unique use an arbitrary assumption that there will be about
    10% as many groups as input tuples --- perhaps someday we can refine this.