From: Sandeep Chibber <sandeep@vreach.net>
To: pgsql-sql@postgresql.org
To: pgsql-sql-owner@postgresql.org
To: pgsql-odbc-owner@postgresql.org
To: pgsql-jdbc-owner@postgresql.org
Cc: pgsql-novice-owner@postgresql.org
Cc: pgsql-general-owner@postgresql.org
Cc: pgsql-bugs-owner@postgresql.org
Cc: pgsql-admin-owner@postgresql.org
Subject: Postgres Function Problem
Date: Tue, 4 Jun 2002 12:22:10 +0530
Message-ID: <002001c20b94$5a1a65e0$1302a8c2@multicast.com> (raw)
Hi,
I am Sandeep Chibber from vReach Solutions. We are using postgres functions with java beans. There is no problem with simple postgres functions which have Simple select statements WITHOUT where clause. But when we have sql statements in the postgres function in which WHERE clause is used ,then we have problem of passing values to the WHERE clause.Like in the following function,how to pass values to $1 an $2 through my java program. In DB2 we use CallableStatement.setString(1,"user_id) to set values to user_id of string(varchar) datatype. Postgres has some other way ,which we are not able to locate.
CREATE FUNCTION tester7 ( varchar, varchar ) returns setof ICDN_EVENTREG as ' SELECT * FROM ICDN_EVENTREG WHERE ICDN_EVENTREG.USER_ID = $1 AND ICDN_EVENTREG.PASSWORD = $2 ;' LANGUAGE SQL
The table structure is as follows
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') ;
So kindly guide us how to pass values to the $1,$2 in WHERE clause through our java beans and also how to execute this function in the pgAdmin II
Thanking in anticipation
Sandeep Chibber
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, pgsql-sql-owner@postgresql.org, pgsql-odbc-owner@postgresql.org, pgsql-jdbc-owner@postgresql.org, pgsql-novice-owner@postgresql.org, pgsql-general-owner@postgresql.org, pgsql-bugs-owner@postgresql.org, pgsql-admin-owner@postgresql.org
Subject: Re: Postgres Function Problem
In-Reply-To: <002001c20b94$5a1a65e0$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