Hello this can help http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Iteration_over_RECORD_variable_inside_trigger Regards Pavel Stehule 2012/5/4 Geo-x <x-lalande@xxxxxxxxxx>: > 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. > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
