Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 5B6289FA2FD
	for <pgsql-bugs-postgresql.org@postgresql.org>;
	Mon, 25 Dec 2006 13:32:25 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 09958-04 for <pgsql-bugs-postgresql.org@postgresql.org>;
	Mon, 25 Dec 2006 13:32:18 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.190])
	by postgresql.org (Postfix) with ESMTP id 488FC9F939F
	for <pgsql-bugs@postgresql.org>; Mon, 25 Dec 2006 13:32:18 -0400 (AST)
Received: by nf-out-0910.google.com with SMTP id x4so4667777nfb
	for <pgsql-bugs@postgresql.org>; Mon, 25 Dec 2006 09:32:17 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=iNoNxaxDQDNN3De1xghFhGyM2PUaSBYz/krgfMzwEnq9vJvGW1/yvb86NA/xA1jPj/9l3NOhVum/+uZaPaawG6feSnhIMNKZcl0iZ5a/AZhPOZdVmXO4WbUt0lMR1SoCqMWR8T4qz/BG+fJ0alZl7R0vbmI++vJiH2Lt6o93HBU=
Received: by 10.49.29.3 with SMTP id g3mr15092148nfj.1167067937192;
	Mon, 25 Dec 2006 09:32:17 -0800 (PST)
Received: by 10.49.40.14 with HTTP; Mon, 25 Dec 2006 09:32:17 -0800 (PST)
Message-ID: <d86a77ef0612250932k15b3a8f1s90ec1c52ef99040b@mail.gmail.com>
Date: Mon, 25 Dec 2006 23:02:17 +0530
From: "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
To: "Sandip G" <sandip@singapore.com>
Subject: Re: [GENERAL] NEED URGENT HELP....
Cc: pgsql-bugs@postgresql.org, pgsql-sql@postgresql.org,
	pgsql-general@postgresql.org
In-Reply-To: <20061221074133.5B05A872DC@cal1-1.us4.outblaze.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_45854_14539657.1167067937150"
References: <20061221074133.5B05A872DC@cal1-1.us4.outblaze.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/212
X-Sequence-Number: 16600

------=_Part_45854_14539657.1167067937150
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

it would match ur query against '1,4' for the corressponding field in the
table.
do u really have one such value for that field in your table, i mean '1,4'
??
it won't search for 1 and 4 separately if that is what you want your query
to work.

~Harpreet


On 12/21/06, Sandip G <sandip@singapore.com> wrote:
>
>  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.
>
>
>
> -- <http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=en-mail_a_01>

------=_Part_45854_14539657.1167067937150
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>select * from sp_get_phase (&#39;sandip&#39;, &#39;oms&#39;, &#39;1,4&#39;) this return a Blank record</div>
<div>&nbsp;</div>
<div>it would match ur query against &#39;1,4&#39; for the corressponding field in the table.</div>
<div>do u really have one such value for that field in your table, i mean &#39;1,4&#39; ??</div>
<div>it won&#39;t search for 1 and 4 separately if that is what you want your query to work.</div>
<div>&nbsp;</div>
<div>~Harpreet<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 12/21/06, <b class="gmail_sendername">Sandip G</b> &lt;<a href="mailto:sandip@singapore.com">sandip@singapore.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<blockquote dir="ltr" style="MARGIN-RIGHT: 0px">
<div>
<div>I am using PostgreSql 8.1 with pgAdmin III. OS is XP.</div></div>
<div>&nbsp;</div>
<div>
<div style="PADDING-RIGHT: 5px; PADDING-LEFT: 5px">this is my function:<br><br>CREATE OR REPLACE FUNCTION sp_get_phase(character varying, character varying, character varying)<br>&nbsp; RETURNS ret_dv_sp_get_phase AS<br>$BODY$
<br>SELECT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BOOK_NO, USER_ID, COMPANY_ID, PHASE, UPDATE_USER_ID, UPDATE_DATE, <br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AddInfo1, AddInfo2<br>FROM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T_PHASE<br>WHERE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (USER_ID = $1) AND (COMPANY_ID = $2) AND BOOK_NO IN ($3)
<br>$BODY$<br>&nbsp; LANGUAGE &#39;sql&#39; VOLATILE;<br><br><br>When I run <br>select * from sp_get_phase (&#39;sandip&#39;, &#39;oms&#39;, &#39;4&#39;) &nbsp; returns 1 record.....this works fine....<br><br>select * from sp_get_phase (&#39;sandip&#39;, &#39;oms&#39;, &#39;1&#39;) &nbsp;returns 1 record.....this also works fine... BUT 
<br><br>select * from sp_get_phase (&#39;sandip&#39;, &#39;oms&#39;, &#39;1,4&#39;) this return a Blank record.<br><br>I tried to execute the SQL statement from the function <br><br>SELECT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BOOK_NO, USER_ID, COMPANY_ID, PHASE, UPDATE_USER_ID, UPDATE_DATE, 
<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AddInfo1, AddInfo2<br>FROM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T_PHASE<br>WHERE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (USER_ID = &#39;testUser&#39;) AND (COMPANY_ID = &#39;testCompany&#39;) AND BOOK_NO IN (1,4)<br><br>----- This Works fine... returns 2 records. &nbsp; What may be the problem? 
<br><br>Thanks in advance.<br>Regards,<br>Sandip.<br>&nbsp;</div></div></blockquote><br>-- <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=en-mail_a_01" target="_blank">
<img alt="" border="0"></a> </blockquote></div><br>

------=_Part_45854_14539657.1167067937150--