Re: Windows query weird result

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(at)staffmail(dot)ed(dot)ac(dot)uk <mailto:lfischer(at)staffmail(dot)ed(dot)ac(dot)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(at)staffmail(dot)ed(dot)ac(dot)uk <mailto:lfischer(at)staffmail(dot)ed(dot)ac(dot)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(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)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(at)bay(dot)k12(dot)fl(dot)us <mailto:ABREUAL(at)bay(dot)k12(dot)fl(dot)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(at)staffmail(dot)ed(dot)ac(dot)uk
+44 131 6517057