Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)

Hi everybody,

I want to thank Basile for his function but I've problems with it.

1- When I tried to apply it in postgres SQL 8.4 on a DB in LATIN1 I've this
message :

ERROR: character 0xe280a2 of encoding "UTF8" has no equivalent in "LATIN1"

2- I tried this function on a DB in UTF8 and I've this message :

ERROR: syntax error at or near "USING"
LIGNE 34 : ...$1).' || ri.column_name || '::text' INTO newValue USING NEW;

3- So, I tried I delete the words USING NEW and USING and when I want to
update or insert a data I've this message :

there is no parameter $1

I don't understand how we can using the parameter $1 in an sql request.

Thank you for your response and sorry for my English.

Geo-x

--
View this message in context: http://postgresql.1045698.n5.nabble.com/OLD-myColumnNameVar-How-to-generically-access-columns-in-a-trigger-s-OLD-or-NEW-records-tp4347470p5685049.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.