From f3567eeaf2423c933166edff320ab1a7093f1ac4 Mon Sep 17 00:00:00 2001
From: Neil Conway
Date: Fri, 20 May 2005 01:29:56 +0000
Subject: Implement md5(bytea), update regression tests and documentation.
 Patch from Abhijit Menon-Sen, minor editorialization from Neil Conway. Also,
 improve md5(text) to allocate a constant-sized buffer on the stack rather
 than via palloc.

Catalog version bumped.
---
 doc/src/sgml/func.sgml | 13 ++++++++++++-
 1 file changed, 12 insertions(+), 1 deletion(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 1b031c0c315..8c6eebc86c5 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.247 2005/05/11 13:58:50 neilc Exp $
+$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.248 2005/05/20 01:29:55 neilc Exp $
 PostgreSQL documentation
 -->
 
@@ -2328,6 +2328,17 @@ PostgreSQL documentation
       <entry><literal>5</literal></entry>
      </row>
 
+     <row>
+      <entry><literal><function>md5</function>(<parameter>string</parameter>)</literal></entry>
+      <entry><type>text</type></entry>
+      <entry>
+       Calculates the MD5 hash of <parameter>string</parameter>,
+       returning the result in hexadecimal.
+      </entry>
+      <entry><literal>md5('Th\\000omas'::bytea)</literal></entry>
+      <entry><literal>8ab2d3c9689aaf18 b4958c334c82d8b1</literal></entry>
+     </row>
+
      <row>
       <entry>
        <literal><function>decode</function>(<parameter>string</parameter> <type>text</type>,
-- 
cgit v1.2.3