Re: Why PostgreSQL?

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(at)mail(dot)nih(dot)gov> wrote:

>
>
> On Wed, Aug 19, 2009 at 6:36 AM, Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)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
>
>