Re: md5() sorting

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: md5() sorting
Date: 2007-11-07 14:54:02
Message-ID: 20071107145402.GA26157@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 07, 2007 at 03:42:11PM +0100, Karsten Hilbert wrote:
> Should I be going about this sorting or hashing or detection
> business in another way entirely which can be done at the
> SQL level ?

I'm wondering if you cast the md5sum as a bytea instead of text and
then sort, if that would solve it simply.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tommy Flewwelling 2007-11-07 14:59:42 The .pgpass file
Previous Message Karsten Hilbert 2007-11-07 14:42:11 md5() sorting