From: V i s h a l Kashyap @ [Sai Hertz And Control Systems] <sank89@sancharnet.in>
To: Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Function Parameters - need help !!!
Date: Mon, 21 Jun 2004 15:12:17 +0530
Message-ID: <40D6AD79.4050701@sancharnet.in> (raw)
In-Reply-To: <77ED2BF75D59D1439F90412CC5B109740DCB4A0F@ie10-sahara.hiso.honeywell.com>
References: <77ED2BF75D59D1439F90412CC5B109740DCB4A0F@ie10-sahara.hiso.honeywell.com>
Dear Pradeep ,
>CREATE PROC PP_ReadPointByValue
>@SessionID int = NULL, --these r default parameters
>
>
SessionID INT := NULL;
>@SPSID int = 1,--default value
>
>
SPSID int := 1 ;
>@ParameterName nvarchar (50) = NULL, -- if NULL read all parameters
>
>
ParameterName varchar(50) := NULL ;
>@NumValue real = NULL,
>@StrValue nvarchar (255) = NULL,
>
>
same as ParameterName varchar(50) := NULL ;
>@ParameterID int = NULL
>
>
ParameterID int := NULL;
Kindly note :
1. This all is for plpgsql procedure
2. All the variable in upcase would be used as lower case i.e
SessionID would be sessionid untll it is not as "SessionID"
3. If a value is not intiliazed it is defaulted to NULL.
--
Best Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com [Comming Soon http://www.saihertz.com]
Yahoo IM: coeb_college[ a t ]yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sank89@sancharnet.in, Pradeepkumar.Pyatalo@honeywell.com
Subject: Re: Function Parameters - need help !!!
In-Reply-To: <40D6AD79.4050701@sancharnet.in>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox