From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Susan Hoddinott <susan@perth.dialix.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: Executing SQL commands via triggers without the use of
Date: Fri, 28 Feb 2003 18:00:05 -0800 (PST)
Message-ID: <20030228175804.N7046-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <001501c2def2$fe2fe9c0$1f84fea9@oemcomputer>
On Fri, 28 Feb 2003, Susan Hoddinott wrote:
> 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?
Not really... You'll need to wrap it in a simple function.
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: sszabo@megazone23.bigpanda.com, susan@perth.dialix.com.au
Subject: Re: Executing SQL commands via triggers without the use of
In-Reply-To: <20030228175804.N7046-100000@megazone23.bigpanda.com>
* 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