Re: [OT] Very strange postgresql behaviour

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.