Peter Eisentraut <[EMAIL PROTECTED]> writes:
> SELECT EXTRACT(QUARTER FROM INTERVAL '200 days') gives 1. Why is that?
Because interval_part does
case DTK_QUARTER:
result = (tm->tm_mon / 3) + 1;
break;
Not sure that changing this is a good
Tom Lane wrote:
> "Eugene M. Hutorny" <[EMAIL PROTECTED]> writes:
> > SQL statemet
> > SELECT EXTRACT(QUARTER FROM INTERVAL '1 day');
> >
> > Returns: 1
> > Expected: 0
>
> Why would you expect that? Quarters are numbered 1 through 4.
> And it doesn't "always return 1":
>
> regression=# SELECT EXT
I expect 0 because
SELECT EXTRACT(YEAR FROM INTERVAL '1 day'), EXTRACT(MONTH FROM INTERVAL '1
day')
returns 0,0
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Eugene M. Hutorny" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, September 21, 2007 7:21 PM
Subject: Re: [BUGS] BUG #36
Cédric Villemain wrote:
> Le jeudi 13 septembre 2007, Tom Lane a écrit :
> > =?ISO-8859-1?Q?St=E9phane_Schildknecht?=
> <[EMAIL PROTECTED]> writes:
> > > It seems the shell command createuser and the SQL CREATE USER don't act
> > > the same way,
> >
> > They aren't really claimed to.
>
> But the
"Eugene M. Hutorny" <[EMAIL PROTECTED]> writes:
> SQL statemet
> SELECT EXTRACT(QUARTER FROM INTERVAL '1 day');
> Returns: 1
> Expected: 0
Why would you expect that? Quarters are numbered 1 through 4.
And it doesn't "always return 1":
regression=# SELECT EXTRACT(QUARTER FROM INTERVAL '3 months
Am Freitag, 21. September 2007 schrieb Eugene M. Hutorny:
> SQL statemet
> SELECT EXTRACT(QUARTER FROM INTERVAL '1 day');
>
> Returns: 1
> Expected: 0
> Or: ERROR: interval units "quarter" not supported
An alternative behavior would be to return something like
ceil($argument / (360/4))
or
The following bug has been logged online:
Bug reference: 3625
Logged by: Brian Barlow
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: Windows (XP)
Description:pg_dump with -Ft (tar) option
Details:
I have been using 8.1.9 and because of
The following bug has been logged online:
Bug reference: 3624
Logged by: Eugene M. Hutorny
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: freebsd6.2
Description:EXTRACT(QUARTER FROM INTERVAL) always returns 1
Details:
Tested on PostgreS
Herouth Maoz wrote:
The following bug has been logged online:
Bug reference: 3616
Logged by: Herouth Maoz
Email address: [EMAIL PROTECTED]
PostgreSQL version: n/a
Operating system: MacOS X 10.4.10
Description:PgAdminIII crashes on copy operation
Details:
PgAdmin f
Tom Lane wrote:
Hmm ... works fine for me in both 8.2.5 and HEAD, which means either
we fixed it since 8.2.4 (but I see nothing relevant in the CVS logs),
or there's something relevant you didn't mention.
One thing to be aware of is that pg_config's path output is not just
hardwired strings; the
10 matches
Mail list logo
