Re: 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: Re: How to make @id or $id as parameter name in plpgsql, is it available?
Date: 2004-11-24 07:20:30
Message-ID: 20041124071721.7B4C82469@shaucon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2004-11-24 08:23:31 lwlocks and starvation
Previous Message Arnold.Zhu 2004-11-24 07:20:06 Re: How to make @id or $id as parameter name in plpgsql, is it available?