Re: BUG #7942: Timestamp "19991231 240000" should not be out of range

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: georg(dot)kindermann(at)gmx(dot)at
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7942: Timestamp "19991231 240000" should not be out of range
Date: 2013-03-15 03:21:59
Message-ID: 20094.1363317719@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

georg(dot)kindermann(at)gmx(dot)at writes:
> select cast('19991231 240000' as timestamp);
> --Produces >ERROR: timestamp out of range<

Oddly enough, I just fixed that last week:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=542eeba26992305d872be699158cb3ab1c2be6e6

Weird how a bug can go unnoticed for ten years and then two people trip
over it at almost the same time.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-03-15 03:49:01 Re: BUG #7943: plpgsql parsing bug
Previous Message hubert depesz lubaczewski 2013-03-15 00:08:38 ERROR: syntax error in tsquery - for high-unicode whitespace