On Wed, Oct 07, 2015 at 12:55:38PM +0200, Karsten Hilbert wrote:
> > > I am dealing with radiology studies aka DICOM data) one would > > > want an md5 function which streams in parts of a large object > > > piece by piece using md5_update and m5_finalize or some such. > > It would certainly be possible to write a lo_md5(oid) function to do > > this, but as far as I'm aware nobody has yet done so. How are your > > C skills? > > I had hoped someone was going to say: "Yeah, right, low > hanging fruit, let's just do it for 9.next" :-)
Someone _with_ C skills, that is.
if the size of blobs is less than 1GB, then it should be possible in plpgsql too.