Quick Links

Executing SQL commands via triggers without the use of procedures

From:	"Susan Hoddinott" <susan(at)perth(dot)dialix(dot)com(dot)au>
To:	<pgsql-sql(at)postgresql(dot)org>
Subject:	Executing SQL commands via triggers without the use of procedures
Date:	2003-02-28 06:31:12
Message-ID:	001501c2def2$fe2fe9c0$1f84fea9@oemcomputer
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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

Attachment	Content-Type	Size
Susan Hoddinott.vcf	application/octet-stream	171 bytes

Responses

Re: Executing SQL commands via triggers without the use of at 2003-03-01 02:00:05 from Stephan Szabo
Re: Executing SQL commands via triggers without the use of procedures at 2003-03-01 16:35:51 from Jeff Eckermann
Re: Executing SQL commands via triggers without the use of procedures at 2003-03-03 13:22:51 from Oleg Samoylov
Re: Executing SQL commands via triggers without the use of procedures at 2003-03-26 23:04:48 from fabio

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Christoph Haller	2003-02-28 09:34:41	Re: Copy from a SELECT
Previous Message	Victor Yegorov	2003-02-28 06:11:37	Re: pgsql problem