| From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: triggers in SQL? |
| Date: | 2000-09-10 21:15:46 |
| Message-ID: | 20000910171546.A6680@klamath.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)home(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2000-09-10 21:29:25 | Re: FOREIGN KEY questions |
| Previous Message | lee johnson | 2000-09-10 20:50:31 | Re: postgres not allowing new database? |