Re: md5() sorting - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: md5() sorting
Date
Msg-id 20071107145402.GA26157@svana.org
Whole thread Raw
In response to md5() sorting  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: md5() sorting  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List 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@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

Attachment

pgsql-general by date:

Previous
From: Rainer Bauer
Date:
Subject: Re: Npsql is much faster than ODBC ?
Next
From: Tommy Flewwelling
Date:
Subject: The .pgpass file