"July" missing from datetime.c

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: "July" missing from datetime.c
Date: 2001-12-18 17:55:52
Message-ID: E16GOR5-0003m6-00@blount.mail.mindspring.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
NotDashEscaped: You need GnuPG to verify this message

Patch below fixes the following problem:

template1=# create table foobar (cdate timestamp);
CREATE
template1=# insert into foobar values('11:23 Friday, Jun 1, 2001 EDT');
INSERT 16558 1
template1=# insert into foobar values('11:23 Friday, June 1, 2001 EDT');
INSERT 16559 1
template1=# insert into foobar values('11:23 Sunday, Jul 1, 2001 EDT');
INSERT 16560 1
template1=# insert into foobar values('11:23 Sunday, July 1, 2001 EDT');
ERROR: Bad timestamp external representation '11:23 Friday, July 7, 2000 EDT'

(Just one line added, so I've inlined the patch)

*** ./src/backend/utils/adt/datetime.c.orig Tue Dec 18 12:30:17 2001
--- ./src/backend/utils/adt/datetime.c Tue Dec 18 12:30:31 2001
***************
*** 272,273 ****
--- 272,274 ----
{"jul", MONTH, 7},
+ {"july", MONTH, 7},
{"julian", UNITS, JULIAN},

Greg Sabino Mullane
greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200112181250

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE8H4KLvJuQZxSWSsgRAqc7AKDyu+5VNq3SB6lWF86Mu+rsnRunmgCfeGNg
fkMXy+oKuEiX4sdV67TaR3I=
=xtAz
-----END PGP SIGNATURE-----

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2001-12-18 22:23:42 Re: [PATCHES] Problem compiling postgres sql --with-tcl
Previous Message Zeugswetter Andreas SB SD 2001-12-18 11:26:06 Re: [HACKERS] Problem compiling postgres sql --with-tcl