From: Susan Hoddinott <susan@perth.dialix.com.au>
To: pgsql-sql@postgresql.org
Subject: Executing SQL commands via triggers without the use of procedures
Date: Fri, 28 Feb 2003 14:31:12 +0800
Message-ID: <001501c2def2$fe2fe9c0$1f84fea9@oemcomputer> (raw)
Hello,
Having scoured the relevant documentation I cannot find anything which indicates how I simply create a database trigger to insert into a second table after insert on a first table, without the use of a procedure. As I do not want return values etc. this seems like overkill. Is it possible to create a trigger which executes SQL directly without the need to create a procedure? If so, what is the syntax?
Regards
Attachments:
Susan Hoddinott.vcf (application/octet-stream, 170B) download
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: susan@perth.dialix.com.au
Subject: Re: Executing SQL commands via triggers without the use of procedures
In-Reply-To: <001501c2def2$fe2fe9c0$1f84fea9@oemcomputer>
* 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