On Thu, Aug 25, 2011 at 13:20, Massa, Harald Armin <chef@xxxxxxx> wrote: > hello, > just tried to lookup the documentation of hashtext. > And I did not find it by: > a) searching the online docs with the integrated searchengine > b) reading through the chapter 9 "functions and operators" > -> within string functions, there is md5(string), but not hashtext. > c) searching postgresql.org with google > -> leads to some mailing-list discussions about hashtext in comparison to > md5 > Am I searching wrong or is the documentation in fact missing? I believe it's considered an internal function, and not one to rely on. If you search the archives, you will find reports around a version upgrade when it changed the output for a certain input and thus broke things for those using it as partitioning key in for example plproxy. IIRC (but I'm too lazy to lookup the discussion right now) the conclusion was that it's not documented because it's internal and you're not supposed to use/rely on it. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
