Date: Mon, 25 Dec 2006 18:45:31 -0500
From: Guy Rouillier <guyr-ml1@burntmail.com>
Subject: Re: NEED URGENT HELP....
In-reply-to: <20061221074133.5B05A872DC@cal1-1.us4.outblaze.com>
To: pgsql-general@postgresql.org
Message-id: <4590629B.9070808@burntmail.com>
MIME-version: 1.0
Content-type: text/plain; charset=ISO-2022-JP
Content-transfer-encoding: 7bit
References: <20061221074133.5B05A872DC@cal1-1.us4.outblaze.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)

Sandip G wrote:
>     WHERE           (USER_ID = $1) AND (COMPANY_ID = $2) AND BOOK_NO IN ($3)

>     select * from sp_get_phase ('sandip', 'oms', '1,4') this return a
>     Blank record.

$3 is a parameter marker for a single value.  You cannot supply a
comma-separated list of values and expect it to operate on them.  As
Harpreet points out, it is interpreting your comma-separated list as a
single value.  If you know you will always have (e.g.) two values you
want to pass, you could code your function with "in ($3, $4)", but if
you want a generalized, variable-length list of values in your IN
clause, you'd need to use dynamic SQL.

-- 
Guy Rouillier