From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Geo-x <x-lalande(at)cc-lacq(dot)fr> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records) |
Date: | 2012-05-04 13:04:33 |
Message-ID: | CAFj8pRBa4rRLWBEPmMFULbd9fHn6NxTv_CwyVYi7wWR-M4BGLQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2012-05-04 13:12:14 | Re: Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records) |
Previous Message | Raghavendra | 2012-05-04 12:03:04 | Re: How to get the physical locations of tables, views, functions etc of Postgresql in Windows & Linux? |