Dear Friends,
Clarification about the support for the usage of % TYPE in Postgres. I am working with postgres 7.3.4 on RH Linux 7.2. Can I use the %TYPE in parameters as in Oracle.
CREATE OR REPLACE FUNCTION public.fn_listtitle(varchar, varchar)
RETURNS refcursor AS
'
DECLARE
ref REFCURSOR;
BEGIN
OPEN ref FOR
SELECT "Lookuptype", "Lookupname"
FROM "Lookups"
WHERE "Lookuptype" = $1 AND
"Lookup_ID " = $2;
END;
'
LANGUAGE 'plpgsql' VOLATILE;
Here can I use as
CREATE OR REPLACE FUNCTION public.fn_listtitle(%Lookups.Lookuptype, %Lookups.Lookup_ID)
Please shed some light.
Regards
Kumar
