Re: triggers in SQL? - Mailing list pgsql-general

From Neil Conway
Subject Re: triggers in SQL?
Date
Msg-id 20000910171546.A6680@klamath.dyndns.org
Whole thread Raw
In response to triggers in SQL?  (Neil Conway <nconway@klamath.dyndns.org>)
List pgsql-general
On Sun, Sep 10, 2000 at 02:36:39PM -0400, Neil Conway wrote:
> I want to write a simple trigger in SQL (i.e. use the trigger to execute
> a simple function written in SQL). I'm having difficulty - CREATE TRIGGER
> complains if the return type of the procedure is not 'OPAQUE', but CREATE
> FUNCTION won't allow me to create SQL functions with a return type of
> OPAQUE.
>
> Am I going about this the wrong way?

Woops. 5 minutes after posting this I realized that rules would probably
be a better choice.

Unless anyone else has any input, sorry to bug everyone.

Neil

--
Neil Conway <neilconway@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

It is dangerous to be right when the government is wrong.
        -- Voltaire

Attachment

pgsql-general by date:

Previous
From: lee johnson
Date:
Subject: Re: postgres not allowing new database?
Next
From: Stephan Szabo
Date:
Subject: Re: FOREIGN KEY questions