quesion on functions calling from php

From: Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com>
To: postgres sql <pgsql-sql(at)postgresql(dot)org>, <pgsql-php-owner(at)postgresql(dot)org>
Subject: quesion on functions calling from php
Date: 2007-04-16 22:58:07
Message-ID: BAY131-W2B7152A114EF6B370FCBFB0520@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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.

What may be the problem?

I am using PEAR object module for the db connections.

Please advise.

Regards
skarthi

_________________________________________________________________
Get a FREE Web site, company branded e-mail and more from Microsoft Office Live!
http://clk.atdmt.com/MRT/go/mcrssaub0540002919mrt/direct/01/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tommy Gildseth 2007-04-17 06:08:29 Re: quesion on functions calling from php
Previous Message saytinh 2007-04-16 03:48:25 i have prolem can you help me