digest data types?

From: Reece Hart <reece(at)harts(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: digest data types?
Date: 2007-04-11 21:41:19
Message-ID: 1176327679.6763.10.camel@snafu.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does anyone have postgresql types for message digests, especially md5
and sha1?

Obviously I could store these as text (as I currently do), but I'm
particularly interested in custom types that store digests as binary
blobs and provide conversion to/from text.

Am I correct in assuming that the space saved by storing digests as
binary (1/2 size of hex) will substantially impact index ins/upd/del
performance or when the digest itself is a large fraction of the rest of
the row size?

Thanks,
Reece

--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeffrey Melloy 2007-04-11 21:44:02 Re: SQL - finding next date
Previous Message Jeffrey Melloy 2007-04-11 21:37:31 Re: SQL - finding next date