From: Dirk Jagdmann <jagdmann@gmail.com>
To: pgsql-sql@postgresql.org
Subject: MD5 sums of large objects
Date: Sun, 8 Apr 2007 19:03:17 +0200
Message-ID: <5d0f60990704081003p615530acx86257a70bff33fa4@mail.gmail.com> (raw)
Hello all together,
I have a database containing lots of large objects. Now I'd like to
compare large objects in my database and I thought of having a
function which creates a hashsum (MD5, SHA-1 or whatever) of my large
object, so I can use that in queries:
create function lo_md5(id oid) returns text...
Now I don't know if something like this is already included in the
PostgreSQL distribution, could be found somewhere on pgfoundry or
thirdly how to do it? If I have to program myself I would go for a
C-language function which would use the libpq large-object functions
to create the hashsums.
--
---> Dirk Jagdmann
----> http://cubic.org/~doj
-----> http://llg.cubic.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jagdmann@gmail.com
Subject: Re: MD5 sums of large objects
In-Reply-To: <5d0f60990704081003p615530acx86257a70bff33fa4@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox