Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net [216.55.132.35]) by postgresql.org (Postfix) with ESMTP id 5474B475A68 for ; Mon, 18 Mar 2002 18:20:40 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g2INKbK00116; Mon, 18 Mar 2002 18:20:37 -0500 (EST) From: Bruce Momjian Message-Id: <200203182320.g2INKbK00116@candle.pha.pa.us> Subject: Re: hashtext function disappears in 7.2? In-Reply-To: <20020316132800.4a414187.gry@ll.mit.edu> To: gry@ll.mit.edu Date: Mon, 18 Mar 2002 18:20:37 -0500 (EST) Cc: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL97 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200203/226 X-Sequence-Number: 7105 george young wrote: > Since I upgraded from 7.0.3 to 7.2, I can't find the > sql function "hashtext". Why has it been discontinued? > > Is there some alternate new way to take a text value and > get an unique integer? I use this as an argument to the contributed > (and invaluable!) user_write_lock_oid(int) function to manage > advisory locks on arbitrary named objects. Can you use MD5 in /contrib/crypto? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026