Thanks Sean. I just want to know which one is better approach to write trigger in PostgreSQL. PL/pgSQL or PL/Perl or PL/Tcl or PL/Python? I know Perl but not aware of Tcl and Python. Any method could replace any other method?
Thanks,
Paresh
On Wed, Aug 19, 2009 at 4:15 PM, Sean Davis
<sdavis2@mail.nih.gov> wrote:
On Wed, Aug 19, 2009 at 6:36 AM, Jignesh Shah
<jignesh.shah1980@gmail.com> wrote:
Yes, I googled but all have listed old differences. No links for latest differences. I want to write triggers in some specific language and want to process updated row using spi_prepare. It would be greate if you could provide example for that?
In postgres, functions can be written in at least perl, c, python, tcl, java, and pl/pgsql. You'll probably want to look at the manual for writing functions and for triggers. If you have problems writing a trigger to do what you want, perhaps you can post back with a test example and we can help.
Sean