views:

24

answers:

1

I've got a tsvector column in a table and I would like to be able to remove a lexeme from the tsvector.

I've started playing around with ts_stat to rebuild a new tsvector, but it seems quite complicated.

Is there a simple way to do it?

+2  A: 

Cast it to text, remove with regexp, and cast back to tsvector.

depesz
I didn't think the cast was enough. Should have tried...Thanks
jlfenaux