Date: Mon, 29 Jan 2007 08:27:06 -0500
From: Bill Moran <wmoran@collaborativefusion.com>
To: arnaulist@andromeiberica.com
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: [OT] Very strange postgresql behaviour
Message-Id: <20070129082706.0ef2df3b.wmoran@collaborativefusion.com>
In-Reply-To: <45BDE6E4.9050805@andromeiberica.com>
References: <45BDE6E4.9050805@andromeiberica.com>
Organization: Collaborative Fusion
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

In response to Arnau <arnaulist@andromeiberica.com>:
> 
>    I have postgresql 7.4.2 running on debian and I have the oddest
> postgresql behaviour I've ever seen.
> 
> I do the following queries:
> 
> 
> espsm_asme=# select customer_app_config_id, customer_app_config_name
> from customer_app_config where customer_app_config_id = 5929 or
> customer_app_config_id = 11527 order by customer_app_config_id;
> 
> 
>   customer_app_config_id | customer_app_config_name
> ------------------------+--------------------------
>                     5929 | INFO
> (1 row)
> 
> 
>    I do the same query but changing the order of the or conditions:
> 
> 
> espsm_asme=# select customer_app_config_id, customer_app_config_name
> from customer_app_config where customer_app_config_id = 11527 or
> customer_app_config_id = 5929 order by customer_app_config_id;
> 
> 
>   customer_app_config_id | customer_app_config_name
> ------------------------+--------------------------
>                    11527 | MOVIDOSERENA TONI 5523
> (1 row)
> 
> 
> 
>    As you can see, the configuration 5929 and 11527 both exists, but
> when I do the queries they don't appear.

[snip]

Just a guess, but perhaps your index is damaged.  Have you tried
REINDEXing?

-- 
Bill Moran
Collaborative Fusion Inc.