Re: [SQL] quesion on functions calling from php

2007-04-16 Thread Tommy Gildseth
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

[SQL] quesion on functions calling from php

2007-04-16 Thread Karthikeyan Sundaram
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