Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux