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

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(at)cc-lacq(dot)fr>:
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general