Postgres Function Call Problem - Mailing list pgsql-sql

From Sandeep Chibber
Subject Postgres Function Call Problem
Date
Msg-id 003501c20863$1c6fd1f0$1302a8c2@multicast.com
Whole thread Raw
List 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




pgsql-sql by date:

Previous
From: "Sandeep Chibber"
Date:
Subject: Problem with the result set of postgres
Next
From: russm
Date:
Subject: alternate idioms for large "IN (...)" lists