X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1156BD1B169 for ; Mon, 21 Jun 2004 06:47:28 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09956-04 for ; Mon, 21 Jun 2004 09:47:20 +0000 (GMT) Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by svr1.postgresql.org (Postfix) with ESMTP id 93A8ED1B18E for ; Mon, 21 Jun 2004 06:47:14 -0300 (ADT) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.27 (built May 12 2004)) id <0HZN00L01JWOIR@ndl1mr1-a-fixed.sancharnet.in> (original mail from sank89@sancharnet.in) for pgsql-sql@postgresql.org; Mon, 21 Jun 2004 15:17:14 +0530 (IST) Received: from [61.0.95.103] by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.27 (built May 12 2004)) with ESMTPA id <0HZN001KUKIPHT@ndl1mr1-a-fixed.sancharnet.in>; Mon, 21 Jun 2004 15:17:14 +0530 (IST) Date: Mon, 21 Jun 2004 15:12:17 +0530 From: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]" Subject: Re: Function Parameters - need help !!! In-reply-to: <77ED2BF75D59D1439F90412CC5B109740DCB4A0F@ie10-sahara.hiso.honeywell.com> To: "Pradeepkumar, Pyatalo (IE10)" Cc: pgsql-sql@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <40D6AD79.4050701@sancharnet.in> Organization: Sai Hertz And Control Systems Pvt Ltd MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 0.7 (Windows/20040616) References: <77ED2BF75D59D1439F90412CC5B109740DCB4A0F@ie10-sahara.hiso.honeywell.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.2 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS, PLING_PLING X-Spam-Level: ** X-Archive-Number: 200406/189 X-Sequence-Number: 18134 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