postgresql.org
>> Cc: Aaron Abreu
>> Subject: Re: [GENERAL] Windows query weird result
>>
>>> Seems like REINDEX INDEX rescored; did the trick.
>>> Any idea how to find out whether a index is corrupted?
>>>
>>> --
>>> Lutz Fischer
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Igor Neyman
> Sent: Tuesday, April 30, 2013 9:30 AM
> To: Lutz Fischer; pgsql-general@postgresql.org
> Cc: Aaron Abreu
> Subject: Re: [GENERAL
> >
>
> Seems like REINDEX INDEX rescored; did the trick.
> Any idea how to find out whether a index is corrupted?
>
> --
> Lutz Fischer
> lfisc...@staffmail.ed.ac.uk
> +44 131 6517057
>
>
> The University of Edinburgh is a charitable body, registered in
> Scotland, with registration number SC0
29, 2013 1:52 PM
>>> To: pgsql-general@postgresql.org
>>> Subject: [GENERAL] Windows query weird result
>>>
>>> Hi,
>>>
>>> had a bit of weird result for a query:
>>> SELECT id FROM spectrum_match WHERE search_id in (788,694,693,685) AND
>
org
>> Subject: [GENERAL] Windows query weird result
>>
>> 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;
>>
>> re
The problem is that I need not 3 rows but 136 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 retur
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Lutz Fischer
> Sent: Monday, April 29, 2013 1:52 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Windows query weird result
>
&g
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
