Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id BFA354759A7
	for <pgsql-sql@postgresql.org>; Fri, 31 May 2002 01:25:35 -0400 (EDT)
Received: from vreach.net (unknown [203.200.123.87])
	by postgresql.org (Postfix) with ESMTP id A4D3047591F
	for <pgsql-sql@postgresql.org>; Fri, 31 May 2002 01:25:25 -0400 (EDT)
Received: from lokhi [194.168.2.19] by vreach.mzi.net [194.168.2.30]
	with SMTP (MDaemon.PRO.v5.0.5.R)
	for <pgsql-sql@postgresql.org>; Fri, 31 May 2002 10:54:17 +0530
Message-ID: <003501c20863$1c6fd1f0$1302a8c2@multicast.com>
From: "Sandeep Chibber" <sandeep@vreach.net>
To: <pgsql-sql@postgresql.org>
Cc: "The Grim Reeper Is Here" <tdodnz@hotmail.com>,
	"Naveen Kaul" <naveenk@systelinc.com>
Subject: Postgres Function Call Problem
Date: Fri, 31 May 2002 10:52:08 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0032_01C20891.36036EF0"
X-Priority: 1
X-MSMail-Priority: High
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-MDRemoteIP: 194.168.2.19
X-Return-Path: sandeep@vreach.net
X-MDaemon-Deliver-To: pgsql-sql@postgresql.org
X-Archive-Number: 200206/6
X-Sequence-Number: 7971

This is a multi-part message in MIME format.

------=_NextPart_000_0032_01C20891.36036EF0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi ,

I want to have function which will have a query which will accept a paramet=
er 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 th=
e 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 wan=
t the value and not an id
=20
Table structure is

CREATE TABLE ICDN_EVENTREG  (  USER_ID VARCHAR(30) NOT NULL ,   PASSWORD VA=
RCHAR(16) ,   EMAIL VARCHAR(80) ,  DEPARTMENT VARCHAR(30) ,   FIRST_NAME VA=
RCHAR(30) ,  LAST_NAME VARCHAR(30) ,    DESIGNATION VARCHAR(30) ,  TYPE VAR=
CHAR(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 =
=3D $1 AND ICDN_EVENTREG.PASSWORD =3D $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=20
Sandeep






------=_NextPart_000_0032_01C20891.36036EF0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>Hi ,<BR><BR>I want to have function which =
will have=20
a query which will accept a parameter from my application and on the basis =
of=20
the parameter retreive a result set.<BR><BR>Normal call through SELECT gets=
 me=20
an number,i guess some kind of id. In the following function i get ouput as=
=20
something like 168269272 .If there are three rows in the table then the val=
ue=20
will be reapeated three times .I want the value and not an id</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;</DIV></FONT>
<DIV><FONT face=3DArial size=3D2>Table structure is<BR><BR>CREATE TABLE=20
ICDN_EVENTREG&nbsp; (&nbsp; USER_ID VARCHAR(30) NOT NULL ,&nbsp;&nbsp; PASS=
WORD=20
VARCHAR(16) ,&nbsp;&nbsp; EMAIL VARCHAR(80) ,&nbsp; DEPARTMENT VARCHAR(30)=
=20
,&nbsp;&nbsp; FIRST_NAME VARCHAR(30) ,&nbsp; LAST_NAME VARCHAR(30)=20
,&nbsp;&nbsp;&nbsp; DESIGNATION VARCHAR(30) ,&nbsp; TYPE VARCHAR(15) ,&nbsp=
;=20
STATUS VARCHAR(15) DEFAULT 'Pending') ;<BR><BR><BR>Function body is as=20
bellow<BR><BR>CREATE FUNCTION tester5(varchar, varchar) RETURNS SETOF=20
ICDN_EVENTREG AS<BR>'SELECT=20
user_id,password,email,department,first_name,last_name,designation,type,sta=
tus=20
FROM&nbsp;&nbsp;&nbsp; ICDN_EVENTREG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;=20
WHERE&nbsp;&nbsp;&nbsp;&nbsp; ICDN_EVENTREG.USER_ID =3D $1 AND=20
ICDN_EVENTREG.PASSWORD =3D $2 ' LANGUAGE 'sql';<BR><BR>I want to Know how<B=
R>1.=20
How to pass parameter to this function<BR>2. How to call this application<B=
R>3.=20
In this function i am selecting all the fields , if i want to select only<B=
R>two=20
or three tuples,then how to go about it<BR>4. If have idea about java bean =
then=20
how to call his function from a Java<BR>Bean.<BR><BR><BR>Thanks=20
<BR>Sandeep<BR><BR><BR><BR><BR></DIV></FONT></FONT></DIV></BODY></HTML>

------=_NextPart_000_0032_01C20891.36036EF0--