Re: Checksum/Hash Functions

From: "Joshua b(dot) Jore" <josh(at)greentechnologist(dot)org>
To: Bryan White <bryan(at)arcamax(dot)com>
Cc: pgsql-general <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: Checksum/Hash Functions
Date: 2002-05-30 14:14:49
Message-ID: Pine.BSO.4.44.0205300914180.8388-100000@kitten.greentechnologist.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Look in contrib/crypto (I think it was crypto). There are some hash
functions and other crpto stuffs in there.

Joshua b. Jore ; http://www.greentechnologist.org ; 1121 1233 1311 200
1201 1302 1211 200 1201 1303 200 1300 1233 1313 1211 1302 1212 1311 1230
200 1201 1303 200 1321 1233 1311 1302 200 1211 1232 1211 1231 1321 200
1310 1220 1221 1232 1223 1303 200 1321 1233 1311 200 1201 1302 1211 232
200 1112 1233 1310 1211 200 1013 1302 1211 1211 1232 201 22

On Thu, 30 May 2002, Bryan White wrote:

> Does PostgreSQL have any built-in check sum or hash functions.
>
> I want to be able to compute a checksum of a string as I display a record to
> the user and when the user updates the record compare the checksum in the
> update statement. I can do the checksum on the client side but it would
> save the overhead of an additional select statement at update time if the
> checksum could be computed on the database backend.
>
> I know I could write my own function to do this but I first wanted to check
> if there was a function already setup to do it. I have looked at the
> documentation but did not find anything.
>
> ---------
> Bryan White
> This email represents the consensus opinion
> of the many voices in my head.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-05-30 14:21:11 Re: Non-linear Performance
Previous Message Shaun Thomas 2002-05-30 14:05:50 Re: horrendous query challenge :-)