From: Sandeep Chibber <sandeep@vreach.net>
To: pgsql-sql@postgresql.org
Cc: The Grim Reeper Is Here <tdodnz@hotmail.com>
Cc: Naveen Kaul <naveenk@systelinc.com>
Subject: Postgres Function Call Problem
Date: Fri, 31 May 2002 10:52:08 +0530
Message-ID: <003501c20863$1c6fd1f0$1302a8c2@multicast.com> (raw)
Hi ,
I want to have function which will have a query which will accept a parameter from my application and on the basis of the parameter retreive a result set.
Normal call through SELECT gets me an number,i guess some kind of id. In the following function i get ouput as something like 168269272 .If there are three rows in the table then the value will be reapeated three times .I want the value and not an id
Table structure is
CREATE TABLE ICDN_EVENTREG ( USER_ID VARCHAR(30) NOT NULL , PASSWORD VARCHAR(16) , EMAIL VARCHAR(80) , DEPARTMENT VARCHAR(30) , FIRST_NAME VARCHAR(30) , LAST_NAME VARCHAR(30) , DESIGNATION VARCHAR(30) , TYPE VARCHAR(15) , STATUS VARCHAR(15) DEFAULT 'Pending') ;
Function body is as bellow
CREATE FUNCTION tester5(varchar, varchar) RETURNS SETOF ICDN_EVENTREG AS
'SELECT user_id,password,email,department,first_name,last_name,designation,type,status FROM ICDN_EVENTREG WHERE ICDN_EVENTREG.USER_ID = $1 AND ICDN_EVENTREG.PASSWORD = $2 ' LANGUAGE 'sql';
I want to Know how
1. How to pass parameter to this function
2. How to call this application
3. In this function i am selecting all the fields , if i want to select only
two or three tuples,then how to go about it
4. If have idea about java bean then how to call his function from a Java
Bean.
Thanks
Sandeep
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: sandeep@vreach.net, tdodnz@hotmail.com, naveenk@systelinc.com
Subject: Re: Postgres Function Call Problem
In-Reply-To: <003501c20863$1c6fd1f0$1302a8c2@multicast.com>
* 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