<tt><font size="+1">Greetings,<br /><br /> I am trying to write a user function on the server to retrive image files.
CurrentlyI wrote the following:<br /> CREATE OR REPLACE FUNCTION perl_getfile(text)<br /> RETURNS OID AS<br />
$BODY$<br/> my $tmpfile = shift;<br /> open my $IFHAND, '<', $tmpfile<br /> or elog(ERROR, qq{could
notopen the file "$tmpfile": $!});<br /> binmode $IFHAND;<br /> my $result = '';<br /> while(my $buffer =
<$IFHAND>)<br/> {<br /> $result .= $buffer;<br /> }<br /> return $result;<br /> $BODY$<br />
LANGUAGE'plperlu';<br /><br /> on the client I do (PHP sniplet):<br /> $result = pg_query($dbcnx, "SELECT
perl_getfile('/home/harel/Misc/At_work.jpg')");<br/><br /> and I get an error:<br /></font><big>Warning: pg_query() [<a
href="http://localhost/mysqlImage1/function.pg-query">function.pg-query</a>]:Query failed: ERROR: invalid input syntax
fortype oid: "ÿØÿà" in /home/harel/Prj/php/testImages/mysqlImage1/image.php<br /><br /> Any recommendation how to do it
right?</big><br/></tt> <pre class="moz-signature" cols="72"><tt>--
Regards.
David Harel,
==================================
Home office +972 77 7657645
Cellular: +972 54 4534502
Snail Mail: Amuka D.N Merom Hagalil 13802 Israel
Email: <a class="moz-txt-link-abbreviated" href="mailto:hareldvd@ergolight-sw.com">hareldvd@ergolight-sw.com</a>
</tt></pre>
