c k <shreeseva.learning@xxxxxxxxx> writes: > 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, There is no server-side behavior that would cause that query to show you a large object's contents instead of its identifying number. I suppose that you have some client-side code that does something magic when it sees a result column of type "lo", and that for some reason this code is not successfully recognizing the case where the column is coming out of a function. Since you've shown us neither the troublesome query nor the client-side code, it's hard to speculate further than that. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
