Skip site navigation (1) Skip section navigation (2)

Function Parameters - need help !!!

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 (view raw or flat)
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
> 
> 

Responses

pgsql-sql by date

Next:From: Luis NevesDate: 2004-06-21 06:29:06
Subject: Strange behaviour updating primary key column.
Previous:From: Stephan SzaboDate: 2004-06-21 05:35:09
Subject: Re: help with Postgres function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group