Re: Dealing with tsvector in fuctions for data split

Oleg Bartunov writes:

> Francisco,
> 
> you need to say us standard information about pg version

Postgresql 8.2 running in FreeBSD.

> error message you got.

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.

Basically I am trying to do partitioning. I have a master table, some 
children which inherit from the master. Inserts will be redirected with a 
trigger from the master to the children. The function I am having the 
problem with is what the trigger calls to do the redirection.