Function Parameters - need help !!!
От | Pradeepkumar, Pyatalo (IE10) |
---|---|
Тема | Function Parameters - need help !!! |
Дата | |
Msg-id | 77ED2BF75D59D1439F90412CC5B109740DCB4A0F@ie10-sahara.hiso.honeywell.com обсуждение исходный текст |
Ответы |
Re: Function Parameters - need help !!!
|
Список | pgsql-sql |
Hi all, I am a new joinee to this mailing list. I am using PostgreSql for my project. We are trying to port a few stored procedures written in SQL to PGSQL. But i am finding difficulties in doing that. I m new to Postgresql....dont know much about it. I tried a lot of books and online documents.....no go. I have problems in passing default values to function paraameters. I would really appreciate if anyone can help me out with this. The function I am trying to port is as follows : CREATE PROC PP_ReadPointByValue @SessionID int = NULL, --these r default parameters @SPSID int = 1,--default value @ParameterName nvarchar (50) = NULL, -- if NULL read all parameters @NumValue real = NULL, @StrValue nvarchar (255) = NULL, @ParameterID int = NULL Now how do I specify default parameters to the arguments in Plpgsql . > With Best Regards > Pradeep Kumar P J > Honeywell_______________________________________ > No.151/1, Doraisanipalya, (Opp. to IIMB) Bannerghatta Rd, Bangalore 560 > 076. > Telephone No +91 80 26588360 / 51197222 xtn. 8211 > Fax No +91 80 26584750 > Website: Honeywell.com > >
В списке pgsql-sql по дате отправления: