executing a function

From: "adivi" <adivi(at)maximizelearning(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: executing a function
Date: 2003-07-09 05:29:26
Message-ID: 006b01c345db$10851f60$5d0410ac@maximizelearning.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Matthew Horoschun 2003-07-09 05:49:20 Re: executing a function
Previous Message Rudi Starcevic 2003-07-08 23:52:07 Logging select statements