Re: Windows query weird result - Mailing list pgsql-general

I would add each of your where fields to the select,

then use all 3 id numbers in the id=

I also run from windows server 2008, and sometimes

have trouble getting it to accept records with nulls.

or, try putting EACH  where condition enclosed in

its own (  )  set.

On Mon, Apr 29, 2013 at 12:52 PM, Lutz Fischer <lfischer@staffmail.ed.ac.uk> wrote:

Hi,

had a bit of weird result for a query:
SELECT id FROM spectrum_match WHERE search_id in (788,694,693,685) AND
rescored IS NOT NULL and dynamic_rank = true ORDER BY ID;

returns (among some 127K other lines):
...
32694548
32694860
...

But if I change the query to:
SELECT id FROM spectrum_match WHERE search_id in (788,694,693,685) AND
rescored IS NOT NULL and dynamic_rank = true and id= 32694801;
I get

32694801

which is omitted from the previous result.

The database is running under windows (I know that's bad - but we had
reasons...).
It only became apparent after we made a copy of the database and run it
under Linux (Debian wheezy).
There the first query returned 136k lines and this id was the first
difference.

Does anybody has an idea what is going on?

It's postgresql 9.2.1 running under a windows 2008 R2 server


Lutz

--
Lutz Fischer
lfischer@staffmail.ed.ac.uk
+44 131 6517057


The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--

####

Aaron Abreu, Systems Consultant
Bay District Schools, Panama City,  FL

Office:  (850) 767-4288
>>FOCUS Student system support

>>IRIS phone alert system support
ABREUAL@bay.k12.fl.us

The information contained in this message may be privileged and confidential and protected
from disclosure. If the reader of this message is not the intended recipient, or an 
employee or agent responsible for delivering this message to the intended recipient, 
you are hereby notified that any dissemination, distribution or copying of this 
communication is strictly prohibited. If you have received this communication in error, 
please notify us immediately by replying to the message and deleting it from your 
computer. Under Florida law, e-mail addresses are public records. If you do not want 
your e-mail address released in response to a public-records request, do not send 
electronic mail to this entity. Instead, contact this office by phone or in writing.

-- 
Lutz Fischer
lfischer@staffmail.ed.ac.uk
+44 131 6517057