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

On 11/7/07, Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
> On Wed, Nov 07, 2007 at 03:54:02PM +0100, Martijn van Oosterhout 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.
>
> Along the lines of
>
>         ... ORDER BY decode(md5('...'), 'hex');
>
> ? I knew I'd ask here ;-)

Maybe using digest(.., 'md5') function from pgcrypto would be better?
It gives bytea immidiately.

--
marko