Re: BUG #1332: wrong results from age function

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: BUG #1332: wrong results from age function
Дата
Msg-id 20041201084519.GB20166@wolff.to
обсуждение исходный текст
Ответ на BUG #1332: wrong results from age function  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Ответы Re: BUG #1332: wrong results from age function  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Mon, Nov 29, 2004 at 11:37:50 +0000,
  PostgreSQL Bugs List <pgsql-bugs@postgresql.org> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      1332
> Logged by:          Robert Grabowski
>
> Email address:      grabba@env.pl
>
> PostgreSQL version: 7.4.6
>
> Operating system:   Linux
>
> Description:        wrong results from age function
>
> Details:
>
> select age('2004-02-01'::date, '2004-01-01'::date);
>   age
> -------
>  1 mon
> (1 row)
>
> select age('2004-03-01'::date, '2004-02-01'::date);
>    age
> ---------
>  29 days
> (1 row)
>
> I think, it should be "1 mon".

I get "1 mon" when I try this:
Welcome to psql 7.4.6, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

area=> select age('2004-03-01'::date, '2004-02-01'::date);
  age
-------
 1 mon
(1 row)

I am actually using a version post 7.4.6 from cvs. I have also built
postgres using integer date time values.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #1334: PREPARE creates bad execution plan (40x
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: BUG #1319: Windows LIB file libecpg.lib not in build or package