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

Hello, Michael Fuhr

Thank you very much for your reply, I'm looking for a method to port our application
with .Net and Sql Server 2000 to linux and mono.

Sql server 2000's stored procedure take parameter like @Id, @Name etc. Then in our C#
programs, use @Id, @Name as Select, Insert, Delete, Update commands' parameter name.
I don't want to change our C# source and stored procedure too much. It contains about
50M of C# source files, and more than 1000 stored procedures.

I want to use @id, @name as plpgsql's parameter, then I've no need to change C# source,
only change Npgsql driver not to trim "@" and stored procedure to plpgsql.

Is my description clear enough to express my thought? Waiting for your further replys.

Thanks & Regards!
         
Arnold.Zhu
2004-11-24