-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, 22 Feb 2008 16:49:10 -0500 "Kynn Jones" <kynnjo@xxxxxxxxx> 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----- ---------------------------(end of broadcast)---------------------------TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
