> I don't think that it is possible to stream the result of a query anyway,
I was unclear. I don't expect query results to stream out to the client. I want the "SELECT md5(OID);" to return a single md5 hash value. It is already possible to "SELECT md5(lo_read(OID));" but that will read the entire large object into memory. I would like the function md5(oid) to _internally_ feed consecutive calls to lo_read() into an updating md5 function and eventually return the final hash. > I'm not sure if there is much to be gained from storing such large > objects in a database. ACID. Permissions. Single access method. > Also, the max size of a value is 1GB. The maximum size is 4 Terabyte ATM for large objects. Karsten Hilbert -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
