On Wed, Nov 07, 2007 at 05:36:47PM +0200, Marko Kreen wrote:
> > > 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');
> >
> Maybe using digest(.., 'md5') function from pgcrypto would be better?
> It gives bytea immidiately.
Sounds better at first, yes, but requires pgcrypto to be
installed on machines onto which GNUmed is to be deployed.
Thanks for the suggestion, though.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
