Re: How to make @id or $id as parameter name in plpgsql, isit available?

following is only program fragment, original program structure is from sample
named Duwamish in ms vs.net 2002.

/////////////////////////////////
private const String ID_PARM = "@id";
private const String NAME_PARM = "@name";

public UserData GetUserById(int id)
{
if ( dataAdapter == null )
{
throw new System.ObjectDisposedException( GetType().FullName );
}

UserData userData = new UserData();

dataAdapter.SelectCommand = GetUserByIdCommand();
dataAdapter.SelectCommand.Parameters[ID_PARM].Value = id;
dataAdapter.Fill(data);

return userData;
}

private SelectCommand GetUserByIdCommand()
{
if ( getUserCommand == null)
{
selectUserByIdCommand = new SelectCommand("user_select_by_id", Configuration.ConnectDB());
selectUserByIdCommand.CommandType = CommandType.StoredProcedure;

ParameterCollection params = selectUserByIdCommand.Parameters;
params.Add(new Parameter(ID_PARM, DbType.Int32));
}
return selectUserByIdCommand;
}
/////////////////////////////////

---------------------------------
CREATE TABLE users (
id serial NOT NULL,
name character varying(32) NOT NULL
);
---------------------------------
CREATE TYPE user_set AS (
id integer,
name character varying(32)
);
---------------------------------
CREATE FUNCTION user_select_by_id("@id" int4)
RETURNS SETOF user_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
2004-11-26