On Mon, 8 Feb 2010 23:01:45 +0300 (MSK) Oleg Bartunov <oleg@xxxxxxxxxx> wrote: > Ivan, > > what's wrong with: > > postgres=# select 'abc:1'::tsvector; > tsvector > ---------- > 'abc':1 Yes you're right. I think I misplaced some quotes. But still, once a vector has no position, I can't add the weights. test=# select setweight('tano'::tsvector, 'A'); setweight ----------- 'tano' (1 row) test=# select setweight('tano:1'::tsvector, 'A'); setweight ----------- 'tano':1A (1 row) Since I'm writing some helper to manipulate tsvectors I was wondering if a) there is any reasonable use case of adding weights to vectors with no position b) I missed any obvious way to add weights to tsvectors that were initially without positions thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general