Re: [BUGS] BUG #2969: Inaccuracies in Solaris FAQ

2007-02-12 Thread Zdenek Kotala
Rich Teer wrote: The following bug has been logged online: Bug reference: 2969 Logged by: Rich Teer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.2 Operating system: Solaris 10 Description:Inaccuracies in Solaris FAQ Details: Hi there, First, many than

[BUGS] BUG #2994: avg() calculates wrong on Interval-type

2007-02-12 Thread Frank F. Burmo
The following bug has been logged online: Bug reference: 2994 Logged by: Frank F. Burmo Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: i386-portbld-freebsd6.1 Description:avg() calculates wrong on Interval-type Details: The following av

[BUGS] BUG #2993: The program "postgres" is needed by initdb but was not found ...

2007-02-12 Thread Filippo Toso
The following bug has been logged online: Bug reference: 2993 Logged by: Filippo Toso Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Windows 2000 SP4 Description:The program "postgres" is needed by initdb but was not found ... Details:

Re: [BUGS] BUG #2993: The program "postgres" is needed by initdb but was not found ...

2007-02-12 Thread Magnus Hagander
Filippo Toso wrote: > The following bug has been logged online: > > Bug reference: 2993 > Logged by: Filippo Toso > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.3 > Operating system: Windows 2000 SP4 > Description:The program "postgres" is needed by initd

Re: [BUGS] BUG #2994: avg() calculates wrong on Interval-type

2007-02-12 Thread Tom Lane
"Frank F. Burmo" <[EMAIL PROTECTED]> writes: > The following avg()-call gives me a result of: "2 days, 27:53:49.359573"... > which must be wrong. There are only 24 hours in a day. That's a false premise. Days and hours/minutes/seconds are independent components of an interval. Some days have 23

Re: [BUGS] BUG #2994: avg() calculates wrong on Interval-type

2007-02-12 Thread Peter Eisentraut
Tom Lane wrote: > "Frank F. Burmo" <[EMAIL PROTECTED]> writes: > > The following avg()-call gives me a result of: "2 days, > > 27:53:49.359573"... which must be wrong. There are only 24 hours in > > a day. > > That's a false premise. Days and hours/minutes/seconds are > independent components of a

Re: [BUGS] BUG #2994: avg() calculates wrong on Interval-type

2007-02-12 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Moreover, my system thinks that the average of '1 day 12 hours' and '8 > hours' is 22 hours, and also that the average of '2 days' and '3 days' > is 2 days and 12 hours, so it does make the assumption that 1 day = 24 > hours. Yeah, that's what it d