Re: [GENERAL] How can I get one OLD.* field in a dynamic query inside a trigger function ?

2009-10-25 Thread Bruno Baguette
Le 24/10/09 22:57, Pavel Stehule a écrit : 2009/10/24 Bruno Baguette bruno.bague...@gmail.com: Which one would you advise me to learn and use, instead of PL/pgSQL ? It depends on what you are know (if you known better perl or pthon). Usually I using mainly plpgsql and on some functions plperl

Re: [GENERAL] How can I get one OLD.* field in a dynamic query inside a trigger function ?

2009-10-24 Thread Bruno Baguette
Le 24/10/09 06:46, Pavel Stehule a écrit : 2009/10/24 Bruno Baguette bruno.bague...@gmail.com: Hello ! I'm trying to write a little trigger function with variable arguments quantity (at least one, but can be 2,3,4 arguments). Theses arguments are fields name, so only varchar variable. Since

Re: [GENERAL] How can I get one OLD.* field in a dynamic query inside a trigger function ?

2009-10-24 Thread Pavel Stehule
2009/10/24 Bruno Baguette bruno.bague...@gmail.com: Le 24/10/09 06:46, Pavel Stehule a écrit : 2009/10/24 Bruno Baguette bruno.bague...@gmail.com: Hello ! I'm trying to write a little trigger function with variable arguments quantity (at least one, but can be 2,3,4 arguments). Theses

Re: [GENERAL] How can I get one OLD.* field in a dynamic query inside a trigger function ?

2009-10-24 Thread Bruno Baguette
Le 24/10/09 22:09, Pavel Stehule a écrit : you can use plperl or plpython for this task. Pavel re-Hello Pavel, I always used plpgsql because I *thought* it was the most powerfull procedural language for stored procedures in PostgreSQL. The fact that PL/pgSQL is most documented than PL/Tcl

Re: [GENERAL] How can I get one OLD.* field in a dynamic query inside a trigger function ?

2009-10-24 Thread Pavel Stehule
2009/10/24 Bruno Baguette bruno.bague...@gmail.com: Le 24/10/09 22:09, Pavel Stehule a écrit : you can use plperl or plpython for this task. Pavel re-Hello Pavel, I always used plpgsql because I *thought* it was the most powerfull procedural language for stored procedures in PostgreSQL.

[GENERAL] How can I get one OLD.* field in a dynamic query inside a trigger function ?

2009-10-23 Thread Bruno Baguette
Hello ! I'm trying to write a little trigger function with variable arguments quantity (at least one, but can be 2,3,4 arguments). Theses arguments are fields name, so only varchar variable. Since it is a dynamic query, I use the EXECUTE statement as explained on

Re: [GENERAL] How can I get one OLD.* field in a dynamic query inside a trigger function ?

2009-10-23 Thread Pavel Stehule
2009/10/24 Bruno Baguette bruno.bague...@gmail.com: Hello ! I'm trying to write a little trigger function with variable arguments quantity (at least one, but can be 2,3,4 arguments). Theses arguments are fields name, so only varchar variable. Since it is a dynamic query, I use the EXECUTE