[SQL] trigger proceedures in sql

2003-07-09 Thread adivi
hi,     can trigger proceedures ( procedures to be executed from within a trigger )         not be written in sql.     i was looking for examples and can find proceedures in 'c' only.   regards-adivi

[SQL] executing a function

2003-07-08 Thread adivi
Hi, i doubt if this should 've gone to the novice group, but it's all sql         i have a function that returns a setof rows from a table testtab :    CREATE FUNCTION "public"."gettesttab" () RETURNS SET