Re: Odd query result

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Odd query result
Дата
Msg-id 14024.1346077087@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Odd query result  (Maximilian Tyrtania <lists@contactking.de>)
Ответы Re: Odd query result
Список pgsql-general
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


В списке pgsql-general по дате отправления: