Re: [BUGS] BUG #4739: strange behavior of EXTRACT(quarter from INTERVAL)

2009-03-28 Thread Tom Lane
Roman Kononov writes: > On 2009-03-28 11:34 Tom Lane said the following: >> If you have an actual use-case for this, what do you think it should do? > I don't have a use-case (other than hypothetical "how many more years > and quarters did it take to complete this particular software project >

Re: [BUGS] BUG #4739: strange behavior of EXTRACT(quarter from INTERVAL)

2009-03-28 Thread Roman Kononov
On 2009-03-28 11:34 Tom Lane said the following: If you have an actual use-case for this, what do you think it should do? I don't have a use-case (other than hypothetical "how many more years and quarters did it take to complete this particular software project than that particular project").

Re: [BUGS] BUG #4739: strange behavior of EXTRACT(quarter from INTERVAL)

2009-03-28 Thread Tom Lane
"Roman Kononov" writes: > Description:strange behavior of EXTRACT(quarter from INTERVAL) Somehow I can't get excited about the definition of EXTRACT(quarter) for zero or negative intervals. If you have an actual use-case for this, what do you think it should do?

[BUGS] BUG #4739: strange behavior of EXTRACT(quarter from INTERVAL)

2009-03-28 Thread Roman Kononov
The following bug has been logged online: Bug reference: 4739 Logged by: Roman Kononov Email address: kono...@ftml.net PostgreSQL version: 8.3.7 Operating system: GNU/Linux x86_64 Description:strange behavior of EXTRACT(quarter from INTERVAL) Details: test=# select