Using % type in Parameters

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

Browse pgsql-sql by date

  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