DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=ALfzucH9oGluMZr4+Vvrgf3rNrR1XLWptE8GZ81NEXEXitbhUwprAfafxbiyUbCMpY
	X207n5AVu8Iu2WE1GvEfsGV2hEMyh353ejPV1pEXGpN+6F8Ska7/L0ADZL0JeQ7A6eN4
	/HVLIL9LJSGYMbCCyvt/LLOlMGwpDRA2cjAHU=
MIME-Version: 1.0
Date: Tue, 17 Mar 2009 17:26:44 +0530
Message-ID: <d8e7a1e30903170456q767429dt4170f19662fbd2c9@mail.gmail.com>
Subject: different results for large objects
From: c k <shreeseva.learning@gmail.com>
To: pgsql-general@postgresql.org, pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=00163646d90ccd809604654f4269

--00163646d90ccd809604654f4269
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

I am getting correct results with following query i.e. binary objects as
they are inserted.

select docimages.* from docimages where docimages.accobjecttype=9 ORDER BY
docimages.docimagename;

but when I created a function as follows, binary objects are not shown,
rather a number represting the large object on the server is shown.

CREATE OR REPLACE FUNCTION software.uf_searchdocimages(integer, integer,
integer)
  RETURNS SETOF docimages AS
$BODY$
--select images for all object of specified type
    select docimages.* from docimages where docimages.accobjecttype= $2
ORDER BY docimages.docimagename;
$BODY$
  LANGUAGE 'sql' VOLATILE SECURITY DEFINER
  COST 1
  ROWS 10;

The problem is arising for a field of type 'lo'. Why this function is not
giving the actual large object?
I am using Windows XP sp3, PostgreSQL 8.3.6.

The table definitions is like below-
CREATE TABLE docimages
(
  diid serial NOT NULL,
  docimagename character varying(50),
  docimage lo,
  accobjectid integer,
  accobjecttype integer,
  CONSTRAINT pk_docimages PRIMARY KEY (diid)
)
WITH (OIDS=FALSE);
Please reply.
Thanks in adavnce.
CPKulkarni

--00163646d90ccd809604654f4269
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I am getting correct results with following query i.e. binary objects as th=
ey are inserted.<br><br>select docimages.* from docimages where docimages.a=
ccobjecttype=3D9 ORDER BY docimages.docimagename;<br><br>but when I created=
 a function as follows, binary objects are not shown, rather a number repre=
sting the large object on the server is shown.<br>
<br>CREATE OR REPLACE FUNCTION software.uf_searchdocimages(integer, integer=
, integer)<br>=A0 RETURNS SETOF docimages AS<br>$BODY$<br>--select images f=
or all object of specified type<br>=A0=A0=A0 select docimages.* from docima=
ges where docimages.accobjecttype=3D $2 ORDER BY docimages.docimagename;<br=
>
$BODY$<br>=A0 LANGUAGE &#39;sql&#39; VOLATILE SECURITY DEFINER<br>=A0 COST =
1<br>=A0 ROWS 10;<br><br>The problem is arising for a field of type &#39;lo=
&#39;. Why this function is not giving the actual large object?<br>I am usi=
ng Windows XP sp3, PostgreSQL 8.3.6.<br>
<br>The table definitions is like below-<br>CREATE TABLE docimages<br>(<br>=
=A0 diid serial NOT NULL,<br>=A0 docimagename character varying(50),<br>=A0=
 docimage lo,<br>=A0 accobjectid integer,<br>=A0 accobjecttype integer,<br>=
=A0 CONSTRAINT pk_docimages PRIMARY KEY (diid)<br>
)<br>WITH (OIDS=3DFALSE);<br>Please reply.<br>Thanks in adavnce.<br>CPKulka=
rni<br>

--00163646d90ccd809604654f4269--