On Mon, Jul 27, 2009 at 10:20 AM, Tom Lane<t...@sss.pgh.pa.us> wrote: > Alvaro Herrera <alvhe...@commandprompt.com> writes: >> We've developed some code to implement fixed-length datatypes for well >> known digest function output (MD5, SHA1 and the various SHA2 types). >> These types have minimal overhead and are quite complete, including >> btree and hash opclasses. > >> We're wondering about proposing them for inclusion in pgcrypto. > > Wasn't this proposed and rejected before? (Or more to the point, > why'd you bother? The advantage over bytea seems negligible.)
well, one nice things about the fixed length types is that you can keep your table from needing a toast table when you have a bytea in it. merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers