pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
hashtext function disappears in 7.2?
2+ messages / 2 participants
[nested] [flat]

* hashtext function disappears in 7.2?
@ 2002-03-16 18:28  george young <gry@ll.mit.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: george young @ 2002-03-16 18:28 UTC (permalink / raw)
  To: pgsql-sql

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.

-- George

-- 
 I cannot think why the whole bed of the ocean is
 not one solid mass of oysters, so prolific they seem. Ah,
 I am wandering! Strange how the brain controls the brain!
	-- Sherlock Holmes in "The Dying Detective"



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: hashtext function disappears in 7.2?
@ 2002-03-18 23:20  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: george young <gry@ll.mit.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2002-03-18 23:20 UTC (permalink / raw)
  To: gry@ll.mit.edu; +Cc: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-03-18 23:20 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-16 18:28 hashtext function disappears in 7.2? george young <gry@ll.mit.edu>
2002-03-18 23:20 ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox