Re: Why PostgreSQL?

From: Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: Serge Fonville <serge(dot)fonville(at)gmail(dot)com>, postgresql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Why PostgreSQL?
Date: 2009-08-19 10:52:01
Message-ID: c11950270908190352sc34f76l1ea244e30657fb94@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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
>
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2009-08-19 11:02:38 Re: Why PostgreSQL?
Previous Message Sean Davis 2009-08-19 10:45:51 Re: Why PostgreSQL?