pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Trigger functions w/o pgsql ?
2+ messages / 2 participants
[nested] [flat]

* Trigger functions w/o pgsql ?
@ 2003-09-01 18:10  weigelt@metux.de
  0 siblings, 1 reply; 2+ messages in thread

From: weigelt@metux.de @ 2003-09-01 18:10 UTC (permalink / raw)
  To: pgsql-sql


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.de
 cellphone: +49 174 7066481	     
---------------------------------------------------------------------
 Diese Mail wurde mit UUCP versandt.      http://www.metux.de/uucp/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Trigger functions w/o pgsql ?
@ 2003-09-01 22:00  Peter Eisentraut <peter_e@gmx.net>
  parent: weigelt@metux.de
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2003-09-01 22:00 UTC (permalink / raw)
  To: weigelt@metux.de; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-09-01 22:00 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-09-01 18:10 Trigger functions w/o pgsql ? weigelt@metux.de
2003-09-01 22:00 ` Peter Eisentraut <peter_e@gmx.net>

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