From: | "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg> |
---|---|
To: | "psql" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Using % type in Parameters |
Date: | 2003-10-28 09:09:47 |
Message-ID: | 030101c39d33$43cdce80$7502a8c0@hdsc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kumar | 2003-10-28 09:15:17 | Re: Error message during compressed backup |
Previous Message | Senthil Kumar S | 2003-10-28 08:54:43 | Re: Error message during compressed backup |