Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id A9B7B9FB674;
	Mon, 16 Apr 2007 19:58:42 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 57304-06; Mon, 16 Apr 2007 19:58:39 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from bay0-omc2-s11.bay0.hotmail.com (bay0-omc2-s11.bay0.hotmail.com
	[65.54.246.147])
	by postgresql.org (Postfix) with ESMTP id E3C9B9FB631;
	Mon, 16 Apr 2007 19:58:08 -0300 (ADT)
Received: from BAY131-W2 ([65.55.136.37]) by bay0-omc2-s11.bay0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.2668);
	Mon, 16 Apr 2007 15:58:07 -0700
Message-ID: <BAY131-W2B7152A114EF6B370FCBFB0520@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_101a43ff-6acc-4586-a683-ee06318982b4_"
X-Originating-IP: [67.116.31.14]
From: Karthikeyan Sundaram <skarthi98@hotmail.com>
To: postgres sql <pgsql-sql@postgresql.org>, <pgsql-php-owner@postgresql.org>
Subject: quesion on functions calling from php
Date: Mon, 16 Apr 2007 15:58:07 -0700
Importance: Normal
MIME-Version: 1.0
X-OriginalArrivalTime: 16 Apr 2007 22:58:07.0123 (UTC)
	FILETIME=[B26D6E30:01C7807A]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200704/148
X-Sequence-Number: 28148

--_101a43ff-6acc-4586-a683-ee06318982b4_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hi,
=20
   I have written a plpgsql function media_format_func(p_in overlay_format_=
type) which returns int
=20
$sql=3D'select * from media_format_func((200,400,'640*481','jpg')::overlay_=
format_type)';
=20
$result =3D $this->objDB->query($sql);
print_r($result,1);
=20
  I should get a value as 10, instead I am getting the Resource ID as 128 w=
hich is wrong I guess I am getting the output as an object and I am not get=
ting the expected resul that I should get. =20
=20
 What may be the problem?
=20
   I am using PEAR object module for the db connections.
=20
  Please advise.
=20
Regards
skarthi
=20
_________________________________________________________________
Get a FREE Web site, company branded e-mail and more from Microsoft Office =
Live!
http://clk.atdmt.com/MRT/go/mcrssaub0540002919mrt/direct/01/=

--_101a43ff-6acc-4586-a683-ee06318982b4_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body>
Hi,<BR>
&nbsp;<BR>
&nbsp;&nbsp; I have written a plpgsql function media_format_func(p_in overl=
ay_format_type) which returns int<BR>
&nbsp;<BR>
$sql=3D'select&nbsp;* from media_format_func((200,400,'640*481','jpg')::ove=
rlay_format_type)';<BR>
&nbsp;<BR>
$result =3D $this-&gt;objDB-&gt;query($sql);<BR>
print_r($result,1);<BR>
&nbsp;<BR>
&nbsp; I should get a value as 10, instead I am getting the Resource ID as =
128 which is wrong I guess I am getting the output as an object and I am no=
t getting the expected resul that I should get.&nbsp; <BR>
&nbsp;<BR>
&nbsp;What may be the problem?<BR>
&nbsp;<BR>
&nbsp;&nbsp; I am using PEAR object module for the db connections.<BR>
&nbsp;<BR>
&nbsp; Please advise.<BR>
&nbsp;<BR>
Regards<BR>
skarthi<BR>
&nbsp;<BR><br /><hr />With Windows Live Hotmail you can now see trouble.bef=
ore he arrives. <a href=3D'http://Newlivehotmail.com' target=3D'_new'>Check=
 it out for yourself.</a></body>
</html>=

--_101a43ff-6acc-4586-a683-ee06318982b4_--