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)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Reply via email to