Executing SQL commands via triggers without the use of procedures

Поиск
Список
Период
Сортировка
От Susan Hoddinott
Тема Executing SQL commands via triggers without the use of procedures
Дата
Msg-id 001501c2def2$fe2fe9c0$1f84fea9@oemcomputer
обсуждение исходный текст
Ответы Re: Executing SQL commands via triggers without the use of  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Executing SQL commands via triggers without the use of procedures  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Re: Executing SQL commands via triggers without the use of procedures  (Oleg Samoylov <olleg@telecom.mipt.ru>)
Список 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
Вложения

В списке pgsql-sql по дате отправления:

Предыдущее
От: Aaron Chu
Дата:
Сообщение: Beginner needs help
Следующее
От: Aaron Chu
Дата:
Сообщение: Beginner needs help