Deyan Chepishev wrote:
> The following bug has been logged online:
>
> Bug reference: 1927
> Logged by: Deyan Chepishev
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 7.4.8, 8.0.3
> Operating system: Linux
> Description: incorrect timestamp returned
> Details:
>
> Postgre:
> 1. PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3
> 20050227 (Red Hat 3.4.3-22.1)
> 2. PostgreSQL 7.4.8 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4
>
> When I run the following query:
>
> select timestamp '2005-09-23 23:59:59.9999999'
>
> I get the following result (note the value of the seconds):
>
> 2005-09-23 23:59:60.00
It's the leap second.
Regards
Gaetano Mendola
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
