Re: [HACKERS] How to make @id or $id as parameter name in plpgsql,is it available?

2004-11-24 Thread Arnold.Zhu
Hello, Francisco Figueiredo Jr. plpgsql did not support @id as parameter(need double-quote), somebody suggest me to use vid for parameter. When use vid as parameter for plpgsql, in C# program we use @vid, Npgql will delete @, then pass vid to plpgsql. So I want to change Npgsql not to delete @

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

2004-11-23 Thread Arnold.Zhu
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

Re: [HACKERS] How to make @id or $id as parameter name in plpgsql, is it available?

2004-11-23 Thread Michael Fuhr
On Thu, Nov 23, 2000 at 11:59:58AM +0800, Arnold.Zhu wrote: 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. No need -- PostgreSQL 8.0 (currently in beta) already supports argument names

Re: [HACKERS] How to make @id or $id as parameter name in plpgsql, is it available?

2004-11-23 Thread Michael Fuhr
On Tue, Nov 23, 2004 at 10:46:54PM -0700, Michael Fuhr wrote: On Thu, Nov 23, 2000 at 11:59:58AM +0800, Arnold.Zhu wrote: Ummm...did you know your clock was four years behind? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of

Re: [HACKERS] How to make @id or $id as parameter name in plpgsql, is it available?

2004-11-23 Thread Arnold.Zhu
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,

Re: [HACKERS] How to make @id or $id as parameter name in plpgsql, is it available?

2004-11-23 Thread Arnold.Zhu
Hello, Michael Fuhr I've changed my clock. Back to future now. ^_^ Thanks Regards! Arnold.Zhu 2004-11-24 === 2004-11-24 13:52:05 You wrote: === On Tue, Nov 23, 2004 at 10:46:54PM -0700, Michael Fuhr wrote: On Thu, Nov 23, 2000 at 11:59:58AM +0800,