Re: digest data types?

On Thu, 2007-04-12 at 15:40 -0700, Reece Hart wrote:
> Does anyone have postgresql types for message digests, especially md5
> and sha1?

I don't know of one offhand, but such a type would be pretty easy to
write.

Without using a custom data type, you can at least store the digest in
base64, or even better use bytea (although neither would be quite as
efficient as using a custom UDT).

> 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?

In most cases, I don't think this would have a significant performance
impact.

-Neil