[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Triggers in Postgres
From:       Richard Huxton <dev () archonet ! com>
Date:       2006-07-31 16:25:01
Message-ID: 44CE2EDD.8000100 () archonet ! com
[Download RAW message or body]

Jasbinder Bali wrote:
> Actually Postgres manual of triggers says that in postgres, you can't 
> write a trigger in conventional sql. You have to write it in a 
> procedural language like C. So wanted some more insight on it.

See chapters 35 - 39 of the manual for details. In particular a 
discussion of plpgsql and an example of writing a trigger using it.

http://www.postgresql.org/docs/8.1/static/plpgsql.html

There are other procedural languages available too: php, ruby, shell, R, 
all of various levels of maturity and with different features.
-- 
   Richard Huxton
   Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
[prev in list] [next in list] [prev in thread] [next in thread]