Search Postgresql Archives

Re: Windows query weird result

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



The problem is that I need not 3 rows but 1360000 rows. So "id=" is not really an option. Tried putting each condition in  brackets - but that did not help either.
But you are right in that it looks like the NULL values are the problem. Leaving that condition out both windows and linux server return the same amount of values...


On 29/04/13 22:01, Aaron Abreu wrote:
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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxx
+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@xxxxxxxxxxxxxx)
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxx
+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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux