From: Sandip G <sandip@singapore.com>
To: pgsql-bugs@postgresql.org
Cc: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: NEED URGENT HELP....
Date: Thu, 21 Dec 2006 02:41:33 -0500
Message-ID: <20061221074133.5B05A872DC@cal1-1.us4.outblaze.com> (raw)
I am using PostgreSql 8.1 with pgAdmin III. OS is XP. this is my
function:
CREATE OR REPLACE FUNCTION sp_get_phase(character varying, character
varying, character varying)
RETURNS ret_dv_sp_get_phase AS
$BODY$
SELECT BOOK_NO, USER_ID, COMPANY_ID, PHASE, UPDATE_USER_ID,
UPDATE_DATE,
AddInfo1, AddInfo2
FROM T_PHASE
WHERE (USER_ID = $1) AND (COMPANY_ID = $2) AND BOOK_NO IN ($3)
$BODY$
LANGUAGE 'sql' VOLATILE;
When I run
select * from sp_get_phase ('sandip', 'oms', '4') returns 1
record.....this works fine....
select * from sp_get_phase ('sandip', 'oms', '1') returns 1
record.....this also works fine... BUT
select * from sp_get_phase ('sandip', 'oms', '1,4') this return a
Blank record.
I tried to execute the SQL statement from the function
SELECT BOOK_NO, USER_ID, COMPANY_ID, PHASE, UPDATE_USER_ID,
UPDATE_DATE,
AddInfo1, AddInfo2
FROM T_PHASE
WHERE (USER_ID = 'testUser') AND (COMPANY_ID = 'testCompany') AND
BOOK_NO IN (1,4)
----- This Works fine... returns 2 records. What may be the problem?
Thanks in advance.
Regards,
Sandip.
--
___________________________________________________
Search for products and services at:
http://search.mail.com
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: sandip@singapore.com, pgsql-bugs@postgresql.org, pgsql-general@postgresql.org
Subject: Re: NEED URGENT HELP....
In-Reply-To: <20061221074133.5B05A872DC@cal1-1.us4.outblaze.com>
References: <20061221074133.5B05A872DC@cal1-1.us4.outblaze.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