Re: md5() sorting
От
Marko Kreen
Тема
Re: md5() sorting
Дата
Msg-id
e51f66da0711070736u64717c36nb0b1f82b9038e8ac@mail.gmail.com
Ответ на
Re: md5() sorting (Karsten Hilbert)
Список
Дерево обсуждения
md5() sorting Karsten Hilbert <Karsten.Hilbert@gmx.net>
Re: md5() sorting Martijn van Oosterhout <kleptog@svana.org>
Re: md5() sorting Karsten Hilbert <Karsten.Hilbert@gmx.net>
Re: md5() sorting "Marko Kreen" <markokr@gmail.com>
Re: md5() sorting Karsten Hilbert <Karsten.Hilbert@gmx.net>
Re: md5() sorting Lew <lew@lwsc.ehost-services.com>
Re: md5() sorting "Scott Marlowe" <scott.marlowe@gmail.com>
On 11/7/07, Karsten Hilbert 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
В списке pgsql-general по дате отправления
