Re: Odd query result - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: Odd query result
Date
Msg-id CAL_0b1tOBviY0xmVy97CpiC+Y=A-Ak11SLYyeOHpC8o=pkKWBw@mail.gmail.com
Whole thread Raw
In response to Re: Odd query result  (Georges Racinet <gracinet@anybox.fr>)
Responses Re: Odd query result  (Georges Racinet <gracinet@anybox.fr>)
List pgsql-general
On Mon, Aug 27, 2012 at 2:37 PM, Georges Racinet <gracinet@anybox.fr> wrote:
> I guess one must also reindex in case some record changes as well, right ?
> Through a trigger maybe ?

You do not need to reindex it in case of record changes. The index
values will be recalculated automatically after committing the
changes.

--
Sergey Konoplev

a database and software architect
http://www.linkedin.com/in/grayhemp

Jabber: gray.ru@gmail.com Skype: gray-hemp Phone: +79160686204


pgsql-general by date:

Previous
From: Georges Racinet
Date:
Subject: Re: Odd query result
Next
From: Georges Racinet
Date:
Subject: Re: Odd query result