Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] date_part() BUG? - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] date_part() BUG?
Date
Msg-id 36C30EAB.E0257FD6@alumni.caltech.edu
Whole thread Raw
In response to date_part() BUG?  (Roberto Joao Lopes Garcia <roberto@mha.com.br>)
List pgsql-hackers
Tree view 
> I´m making tests for data types and I wonder if the following  is a 
> bug!
> using age() function I get: @ 1 hour 13 mins 27.88 secs
> using date_part() over age() I get:
<snip tests for years through seconds>
> But
> 1 for 'decade'     NOT OK!
> 1 for 'century'    NOT OK!
> 1 for 'millenium'    NOT OK!

I can see that here. Will look at it. Thanks for the report...
                 - Tom

pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] TIME QUALIFICATION
Next
From: "Jackson, DeJuan"
Date:
Subject: Temp tables