Re: [BUGS] BUG #2117: inconsistency in sum

2005-12-15 Thread Michael Fuhr
[Please copy the mailing list on replies.] On Thu, Dec 15, 2005 at 07:32:54PM +0100, Adam Kolany wrote: > Michael Fuhr napisa?(a): > >On Thu, Dec 15, 2005 at 11:03:55AM +, Adam Kolany wrote: > >>stoff=> select sum(wplyw),sum(wydatek), sum(wplyw)-sum(wydatek) from > >>rachunki where okres<6; >

Re: [BUGS] BUG #2116: Searching text fields does not work in EUC_JP

2005-12-15 Thread Tom Lane
"Jon Keating" <[EMAIL PROTECTED]> writes: > I have a database with the default encoding set to EUC_JP and the client > (using pgAdmin III) is set to EUC_JP as well. Is the database's locale set to something that works with EUC_JP? You can't just whack the encoding around without paying attention

Re: [BUGS] BUG #2117: inconsistency in sum

2005-12-15 Thread Tom Lane
"Adam Kolany" <[EMAIL PROTECTED]> writes: > can you explain this? > == > stoff=> select sum(wplyw),sum(wydatek), sum(wplyw)-sum(wydatek) from > rachunki where okres<6; > sum | sum | ?column? > ---+-+-- > 73745 | 6712.5

Re: [BUGS] BUG #2117: inconsistency in sum

2005-12-15 Thread Michael Fuhr
On Thu, Dec 15, 2005 at 11:03:55AM +, Adam Kolany wrote: > can you explain this? > == > stoff=> select sum(wplyw),sum(wydatek), sum(wplyw)-sum(wydatek) from > rachunki where okres<6; > sum | sum | ?column? > ---+-+-

[BUGS] BUG #2117: inconsistency in sum

2005-12-15 Thread Adam Kolany
The following bug has been logged online: Bug reference: 2117 Logged by: Adam Kolany Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Linux, SuSe 9.2 Description:inconsistency in sum Details: can you explain this?

[BUGS] BUG #2116: Searching text fields does not work in EUC_JP

2005-12-15 Thread Jon Keating
The following bug has been logged online: Bug reference: 2116 Logged by: Jon Keating Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.1 Operating system: Win 2003 Description:Searching text fields does not work in EUC_JP Details: Hello, I found a problem wit