Re: Odd query result

Maximilian Tyrtania <lists@contactking.de> writes:
>> It might be a broken index issue. Please show the EXPLAIN for these queries.

> It was. I had an index like this:

> CREATE INDEX idx_firmen_iskunde_index
>  ON firmen
>  USING btree
>  (f_firmen_iskunde(firmen.*));

> Sorry, should have mentioned that�Dropping and recreating it fixed it.

Hm, had you changed the behavior of that function since creating the
index?

            regards, tom lane