Thread: Trigger functions w/o pgsql ?

Trigger functions w/o pgsql ?

From
weigelt@metux.de
Date:
Hi folks,

is it somehow possible to create trigger functions directly in
SQL language, w/o an procedural language ? 

Why cant the return value of an function simply be ignored, 
instead of requiring the function to return void (which an sql
function can't return) ?


cu
-- 
---------------------------------------------------------------------Enrico Weigelt    ==   metux IT services
phone:     +49 36207 519931         www:       http://www.metux.de/     fax:       +49 36207 519932         email:
contact@metux.decellphone:+49 174 7066481         
 
---------------------------------------------------------------------Diese Mail wurde mit UUCP versandt.
http://www.metux.de/uucp/


Re: Trigger functions w/o pgsql ?

From
Peter Eisentraut
Date:
weigelt@metux.de writes:

> is it somehow possible to create trigger functions directly in
> SQL language, w/o an procedural language ?

No.

> Why cant the return value of an function simply be ignored,
> instead of requiring the function to return void (which an sql
> function can't return) ?

Internal reasons mostly, but not trivial to overcome.

-- 
Peter Eisentraut   peter_e@gmx.net