Help | Site Map
Connecting Tech Pros Worldwide
Reply
 
LinkBack Thread Tools
  #1  
Old September 4th, 2008, 09:12 PM
Newbie
 
Join Date: Sep 2008
Posts: 1
Default Is index on column updated if the column is updated but data does not change?

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.
Thanks
riya
Reply
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles