| From: | Francisco Reyes <lists(at)natserv(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | pgsql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: CRC function? |
| Date: | 2002-07-08 17:01:11 |
| Message-ID: | 20020708130022.S37019-100000@zoraida.natserv.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 8 Jul 2002, Bruce Momjian wrote:
> Francisco Reyes wrote:
> > Looked at contrib and didn't see it.
> > Anyone knows if there is a CRC fuction available for PostgreSQL.
> >
> > As an example of how I would use it.
> > Imagine a table with 3 columns
> > id,text, crc_val
> >
> > I could then do something like:
> > select id from <table> where crc(text) <> crc_val;
>
> Sure see contrib/pgcrypto/README:
>
> Hashes: MD5, SHA1, CRC32, CRC32B, GOST, TIGER, RIPEMD160,
CRC32 is not installed/supported.
Wrote to the author asking him how difficult it would be to add.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2002-07-08 17:02:04 | Re: Bug in 7.2.1? -- ERROR: Adding columns with defaults is not implemented. |
| Previous Message | Andrew Sullivan | 2002-07-08 16:44:18 | Re: Some Solaris notes, and an invitation |