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 in a function's argument list, although I think only PL/pgSQL currently does anything with them. > CREATE FUNCTION users_select_by_id(@id int4) Change @id to be a valid identifier name and it should work. You can keep using @id if you double-quote it as "@id". If that's not what you meant then please be more specific. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
