Postgres Function Call Problem

From: "Sandeep Chibber" <sandeep(at)vreach(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: "The Grim Reeper Is Here" <tdodnz(at)hotmail(dot)com>, "Naveen Kaul" <naveenk(at)systelinc(dot)com>
Subject: Postgres Function Call Problem
Date: 2002-05-31 05:22:08
Message-ID: 003501c20863$1c6fd1f0$1302a8c2@multicast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2002-05-31 06:36:53 Re: Math Huh?
Previous Message Larry Rosenman 2002-05-31 00:36:57 Re: Math Huh?