Re: PostgreSQL's hashing function?

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: PostgreSQL's hashing function?
Дата
Msg-id 20080222135755.1e90a622@commandprompt.com
обсуждение исходный текст
Ответ на PostgreSQL's hashing function?  ("Kynn Jones" <kynnjo@gmail.com>)
Ответы Re: PostgreSQL's hashing function?
Список 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 по дате отправления:

Предыдущее
От: "Kynn Jones"
Дата:
Сообщение: PostgreSQL's hashing function?
Следующее
От: "Kynn Jones"
Дата:
Сообщение: Queries w/ "computed" table names? (eval in Pg?)