How to make @id or $id as parameter name in plpgsql, is it available?

From: "Arnold(dot)Zhu" <joint(at)shaucon(dot)com>
To: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: How to make @id or $id as parameter name in plpgsql, is it available?
Date: 2000-11-23 03:59:58
Message-ID: 20041123035703.3EFDBE8F@shaucon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello, pgsql-hackers

Can I change postgresql's source to make the following plpgsql works ?
If could, would you please tell me where can i change the source?
I want to try it.

-------------------------------------------------------
CREATE FUNCTION users_select_by_id(@id int4)
RETURNS SETOF users_set
AS '

declare rec record;

begin

for rec in
select * from users where id = @id
loop
return next rec;
end loop;
return;

end; 'LANGUAGE plpgsql;
-------------------------------------------------------

Thanks & Regards

Arnold.Zhu
2000-11-23

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2000-11-23 04:00:26 Breaking of existing apps with CVS version
Previous Message Tom Lane 2000-11-23 03:44:05 Re: RE: ALTER TABLE...ADD CONSTRAINT?