[GENERAL] different results for large objects

2009-03-17 Thread c k
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

Re: [GENERAL] different results for large objects

2009-03-17 Thread Tom Lane
c k shreeseva.learn...@gmail.com 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

Re: [GENERAL] different results for large objects

2009-03-17 Thread c k
Yes, the problem is with PGAdmin and ODBC connection to MS access. The function (given is first mail) is giving same results i.e. only IDs not the actual data from PGAdmin and ODBC. But for following query PGAdmin gives again only IDs, but MS Access through ODBC gives the actual binary data.