Dealing with tsvector in fuctions for data split
От | Francisco Reyes |
---|---|
Тема | Dealing with tsvector in fuctions for data split |
Дата | |
Msg-id | cone.1186376980.422933.36134.1000@zoraida.natserv.net обсуждение исходный текст |
Ответы |
Re: Dealing with tsvector in fuctions for data split
Re: Dealing with tsvector in fuctions for data split |
Список | pgsql-general |
I am trying to create a function to handle inserts in a database with partitions in a particular table. 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 $$; The problem I am running into is that one of the fields is a tsvector and when I try to concatenate it wit the rest of the string it gives an error. The only thing I can think of so far is to start a transaction, insert without the tsvector and then do an update to get the tsvector in. Anyone else had to deal with tsvectors in a fuction? I am copying some existing data so all the rows already have the tsvector. If nothing else works I may just not deal with the tsvector in the function and see if I just re-create the tsvector for each record as I am insert the data.
В списке pgsql-general по дате отправления: