[SQL] executing a function

[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 SETOF public.testtab AS'    
    select * from TestTab;    'LANGUAGE 
'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

 
"volatile" etc. was added by the EMS 
PostGreSql Manager.
 
i try to execute this function
 
but a call 
"select * from gettesttab();"
or
"select gettesttab();"
return the error
ERROR:  syntax error at or near "select"
 
the postmaster window also logs the erros:
ERROR:  syntax error at or near "select"WARNING:  plpgsql: 
ERROR during compile of gettesttab near line 1
 
can simeone please help me out with 
this.  
 
thanks in advance
    
regards-pawan

[SQL] trigger proceedures in sql

[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