Details
-
Improvement
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
None
-
None
-
PostgreSQL oid blob
Description
Using PostgreSQL oid blob, the PostgreSQL jdbc driver does not know if the oid is a blob or not. The user must issue getBlob to return the blob. getObject will return an Integer with the oid value.
select imagedata from person (where imagedata is a oid blob column)
does return an Integer. I guess this is okay as the jdbc driver are not able to provide the Blob as the jdbc type and ResultSet.getObject returns an Integer.
select #result('imagedata' 'java.sql.Blob' 'imagedata') from person
does also return an Integer, but should return an Blob.