subject:"\[SQL\] executing a function"

Re: [SQL] executing a function

2003-07-08 Thread Matthew Horoschun

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. ---(end of broadcast)---

[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