From: | "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Function Parameters - need help !!! |
Date: | 2004-06-21 06:21:19 |
Message-ID: | 77ED2BF75D59D1439F90412CC5B109740DCB4A0F@ie10-sahara.hiso.honeywell.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Luis Neves | 2004-06-21 06:29:06 | Strange behaviour updating primary key column. |
Previous Message | Stephan Szabo | 2004-06-21 05:35:09 | Re: help with Postgres function |