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

From Pavel Stehule
Subject Re: Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)
Date
Msg-id CAFj8pRBa4rRLWBEPmMFULbd9fHn6NxTv_CwyVYi7wWR-M4BGLQ@mail.gmail.com
Whole thread Raw
In response to Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)  (Geo-x <x-lalande@cc-lacq.fr>)
Responses Re: Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)
List pgsql-general
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@cc-lacq.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z)
Next
From: Merlin Moncure
Date:
Subject: Re: Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)