Postgres Pro
Downloads
Home   >   mailing lists

Thread: executing a function

executing a function

From
"adivi"
Date:
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

Re: executing a function

From
Matthew Horoschun
Date:
Hi Pawan,

>    CREATE FUNCTION "public"."gettesttab" () RETURNS SETOF
> public.testtab AS'
>         select * from TestTab;
>     'LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

You want LANGUAGE 'sql'

Cheers

Matthew.