Skip site navigation (1) Skip section navigation (2)

digest data types?

From: Reece Hart <reece(at)harts(dot)net>
To: SF PostgreSQL <sfpug(at)postgresql(dot)org>
Subject: digest data types?
Date: 2007-04-12 22:40:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: sfpug
I've asked a question about message digests data types on pgsql-general
several times. No one's answered. It reminds me of a childhood refrain
"No one likes me, everyone hates me, I'm going to eat some worms".
Anyway, I'm reposting the question here.

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?


Reece Hart,, GPG:0x25EC91A0


sfpug by date

Next:From: Neil ConwayDate: 2007-04-12 22:56:00
Subject: Re: digest data types?
Previous:From: Josh BerkusDate: 2007-04-05 19:42:17
Subject: Help! J2EE Medical Application contact info?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group