From: Sandeep Chibber <sandeep@vreach.net>
To: pgsql-sql@postgresql.org
Subject: Problem with the result set of postgres
Date: Tue, 28 May 2002 14:41:02 +0530
Message-ID: <00bc01c20627$96dad450$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.
You have helped me in getting the result set but if want to pass a parameter
in the WHERE Claues ,i have no idea.
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',DOJ TIMESTAMP) ;
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,stat
us 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 for your prompt reply. You are saving me from lot of trouble.
Thanks again
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
Subject: Re: Problem with the result set of postgres
In-Reply-To: <00bc01c20627$96dad450$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