Re: [OT] Very strange postgresql behaviour

[Bill Moran <wmoran(at)collaborativefusion(dot)com>]

In response to Arnau <arnaulist(at)andromeiberica(dot)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.