On Sat, Mar 7, 2009 at 7:33 PM, V S P <toreason@xxxxxxxxxxx> wrote: > I would like to have a function > given a user id varchar(64) to get a hash number between 0 and 255. > > I first tried md5 but the number it returns is very big and cannot > be converted to an INT > > there is likely a way to simply add ascii values of the userId together > to get a small integer, but wanted to know if there are any other > 'built-in' ways > > this is to get the database id based on user id. In psql type this: \df *hash* -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
