Re: Executing SQL commands via triggers without the use of - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Executing SQL commands via triggers without the use of
Date
Msg-id 20030228175804.N7046-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Executing SQL commands via triggers without the use of procedures  ("Susan Hoddinott" <susan@perth.dialix.com.au>)
List pgsql-sql
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.




pgsql-sql by date:

Previous
From: dhoubrechts
Date:
Subject: use of geometric types in select ?
Next
From: Greg Stark
Date:
Subject: Re: Beginner needs help