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
|