pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jonathan Gardner <jgardner@jonathangardner.net>
To: adivi <adivi@maximizelearning.com>
To: pgsql-sql@postgresql.org
Subject: Re: trigger proceedures in sql
Date: Thu, 10 Jul 2003 12:16:06 -0700
Message-ID: <200307101216.07977.jgardner@jonathangardner.net> (raw)
In-Reply-To: <004401c346a5$bbf0bb50$5d0410ac@maximizelearning.com>
References: <004401c346a5$bbf0bb50$5d0410ac@maximizelearning.com>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 09 July 2003 22:40, adivi wrote:
> hi,
>
>       can trigger proceedures ( procedures to be executed from within a
> trigger ) not be written in sql.
>
>       i was looking for examples and can find proceedures in 'c' only.
>

You may write them in PL/pgSQL, PL/Python, etc... Each language has examples 
on how to set up triggers. So you will need to read about PL/pgSQL and 
PL/Python to figure out how to write triggers in those languages.

I don't think you can write triggers in pure SQL.

- -- 
Jonathan Gardner <jgardner@jonathangardner.net>
(was jgardn@alumni.washington.edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/Dbt3WgwF3QvpWNwRAiRvAJ4ojWIGRGeuTQHY5ckOnepy0LBu9gCgoTl1
XaM7clW3uelccH/w0iaAA/k=
=R7do
-----END PGP SIGNATURE-----



view thread (8+ messages)  latest in thread

Message-ID: <200307101216.07977.jgardner@jonathangardner.net>
Permalink:  ../200307101216.07977.jgardner@jonathangardner.net/
Also on:    postgresql.org/message-id/200307101216.07977.jgardner@jonathangardner.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jgardner@jonathangardner.net, adivi@maximizelearning.com
  Subject: Re: trigger proceedures in sql
  In-Reply-To: <200307101216.07977.jgardner@jonathangardner.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox