Re: Dealing with tsvector in fuctions for data split

Francisco Reyes writes:

> ERROR:  operator does not exist: text || tsvector
>
>> Also, it'd be worth to show simplified version of your function, which
>> demonstrates your problem.
>
>
> I did include that.
>
>>> The function looks like:
>>> AS $$
>>> DECLARE
>>>   v_sql TEXT;
>>> BEGIN
>>>   v_sql := 'INSERT INTO messagecatalog_'||
>>> to_char(NEW.timestampfield,'YYYY')||
>>>   '(field1, field2) values ('
>>> ||New.field1||','||New.field2||')
>>> ')';
>>>   EXECUTE v_sql;
>>>   RETURN NULL;
>>> END
>>> $$;
>
> In the code above field1 is text and field2 is tsvector.


Any suggestions?
Anyone else has dealt with tsvectors in a partition environment?
If sow how did you get the split function/rule to insert into the child
table?