Re: PostgreSQL's hashing function? - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: PostgreSQL's hashing function?
Date
Msg-id 20080222135755.1e90a622@commandprompt.com
Whole thread Raw
In response to PostgreSQL's hashing function?  ("Kynn Jones" <kynnjo@gmail.com>)
Responses Re: PostgreSQL's hashing function?
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 22 Feb 2008 16:49:10 -0500
"Kynn Jones" <kynnjo@gmail.com> wrote:

> Hi!
> Does PostgreSQL expose its hash function?  I need a fast way to hash a
> string to a short code using characters in the set [A-Za-z0-9_].
> (I'm not sure yet how long this code needs to be, but I think even
> something as short as length 2 may be enough.)

Is md5 good enough? :)

select md5()

> 
> TIA!
> 
> Kynn


- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHv0VjATb/zqfZUUQRAqUNAJ9zejT/pN1uIDtQYEQ7TQvt0LqFjACfelSy
wNa9NNUN8rAfmeqwrKCvUb0=
=H8DS
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: "Kynn Jones"
Date:
Subject: PostgreSQL's hashing function?
Next
From: "Kynn Jones"
Date:
Subject: Queries w/ "computed" table names? (eval in Pg?)