Re: [BUGS] BUG #6131: Query Returning Incorrect Results

2011-07-26 Thread David Johnston
-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Tuesday, July 26, 2011 7:42 PM To: David Johnston Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #6131: Query Returning Incorrect Results "David Johnston" writes: > The embedded script exhibits

Re: [BUGS] BUG #6131: Query Returning Incorrect Results

2011-07-26 Thread Tom Lane
"David Johnston" writes: > The embedded script exhibits some strange behavior. When the query is run > the [adjustment_paid] column for [technician] "6338B" should show +/- 25.00. > Instead, if I run the last query immediately after creating the schema and > inserting the data the results I get

[BUGS] BUG #6131: Query Returning Incorrect Results

2011-07-26 Thread David Johnston
The following bug has been logged online: Bug reference: 6131 Logged by: David Johnston Email address: pol...@yahoo.com PostgreSQL version: 9.0.4 Operating system: Windows 7 64-bit Description:Query Returning Incorrect Results Details: The embedded script exhibits s