By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,968 Members | 1,691 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,968 IT Pros & Developers. It's quick & easy.

Is index on column updated if the column is updated but data does not change?

P: 1
I have a BEFORE UPDATE trigger on a table that calls the tsvector_update_trigger() built in function to update a tsvector field.
Since this trigger is called for every update to the table, the trigger function will be called even when the tsvector related field is not updated.
My question is, does the index on that tsvector column get updated each time, even though the column is being updated with the same value? If it is I could replace the build in tsvector_update_trigger() function with my own trigger function that does a check before, if not I could just keep things the way they are.
Sep 4 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 700
I do some tests and it looks that index is always updated.
Feb 21 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.