Postgres Pro
Downloads
Home   >   mailing lists

BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns 1 - Mailing list pgsql-bugs

From Eugene M. Hutorny
Subject BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns 1
Date
Msg-id 200709211225.l8LCPOAi067245@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns 1  (Peter Eisentraut <peter_e@gmx.net>)
Re: BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns 1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      3624
Logged by:          Eugene M. Hutorny
Email address:      eugene@ksf.kiev.ua
PostgreSQL version: 8.2.4
Operating system:   freebsd6.2
Description:        EXTRACT(QUARTER FROM INTERVAL) always returns 1
Details:

Tested on PostgreSQL Versions:
PostgreSQL 8.2.4 on i386-portbld-freebsd6.2, compiled by GCC cc (GCC) 3.4.6
[FreeBSD] 20060305
PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)

SQL statemet
SELECT EXTRACT(QUARTER FROM INTERVAL '1 day');

Returns: 1
Expected: 0
      Or: ERROR: interval units "quarter" not supported

pgsql-bugs by date:

Previous
From: Dave Page
Date:
Subject: Re: BUG #3616: PgAdminIII crashes on copy operation
Next
From: "Brian Barlow"
Date:
Subject: BUG #3625: pg_dump with -Ft (tar) option