How to make @id or $id as parameter name in plpgsql, is it available? - Mailing list pgsql-hackers

From Arnold.Zhu
Subject How to make @id or $id as parameter name in plpgsql, is it available?
Date
Msg-id 20041123035703.3EFDBE8F@shaucon.com
Whole thread Raw
Responses Re: How to make @id or $id as parameter name in plpgsql, is it available?
List 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 = @idloop    return next rec;end loop;return;

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


Thanks & Regards

Arnold.Zhu
2000-11-23






pgsql-hackers by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: [Testperf-general] Re: ExclusiveLock
Next
From: Tom Lane
Date:
Subject: Re: Plperl Safe version check fails for Safe 2.09