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: | 1176417648.4806.57.camel@snafu.site |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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?
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2007-04-12 22:56:00 | Re: digest data types? |
Previous Message | Josh Berkus | 2007-04-05 19:42:17 | Help! J2EE Medical Application contact info? |