Re: "July" missing from datetime.c

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: "July" missing from datetime.c
Date: 2001-12-19 07:33:13
Message-ID: 3C2042B9.E7811888@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

> 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)
> {"jul", MONTH, 7},
> + {"july", MONTH, 7},
> {"julian", UNITS, JULIAN},

Got it, thanks. I'll commit a fix in the next day or so. Note that this
table *must* be strictly ordered to allow the optimized table lookup to
work. So, you should place "july" after "julian", not before.

- Thomas

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Christopher Kings-Lynne 2001-12-19 08:48:59 Patch to fix float8 test on FreeBSD/alpha
Previous Message Peter Eisentraut 2001-12-18 22:23:42 Re: [PATCHES] Problem compiling postgres sql --with-tcl