RFC: CRC datatype

From: "Horst Herb" <hherb(at)malleenet(dot)net(dot)au>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: RFC: CRC datatype
Date: 2000-12-08 08:06:25
Message-ID: 009001c060ed$c2c6d4a0$fcee2bcb@midgard
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I believe that there are many good points to have CRC facilities "built
int", and I failed to detect any arguments against it. In my domain (the
medical domain) we simply can't use data without "proof" of integrity
("proof" as in highest possible level of confidence within reasonable
effort)

Therefore, I propose defining new data types like "CRC32", "CRC64",
"RIPEMD", whatever (rather than pluggable arbitrary CRCs).

Similar as with the SERIAL data type, the CRC data type would generate
automatically a trigger function that calculates a CRC across a tuple
(omitting the CRC property of course, and maybe the OID as well) before each
update and store it in itself.

Is there anything wrong with this idea?

Can somebody help me by pointing me into the right direction to implement
it? (The person who implemeted the SERIAL data type maybe ?)

Regards,
Horst

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2000-12-08 08:08:22 RE: RFC: CRC datatype
Previous Message Andrew Nosenko 2000-12-08 07:33:46 Re: Oracle-compatible lpad/rpad behavior