Karthikeyan Sundaram wrote:
Hi,
I have written a plpgsql function media_format_func(p_in
overlay_format_type) which returns int
$sql='select * from
media_format_func((200,400,'640*481','jpg')::overlay_format_type)';
$result = $this->objDB->query($sql);
print_r($result,1);
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 not getting the expected resul that I should get.
Try one of the methods $this->objDB->getRow($sql),
$this->objDB->getAll($sql) or $this->objDB->getOne($sql) instead.
Also, have a look at the documentation at pear.php.net
--
Tommy
www.gildseth.com
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
