Re: bytea, index and like operator again and detailed

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

- -- Joe Conway <mail(at)joeconway(dot)com> wrote:

> Please try the attached patch and let me know how it works for you. It is
> against cvs HEAD, but should apply OK to 7.4.

so, I checked it with my database.
It looks good, all checks I made are OK.

I realised, that converting my text column to bytea is much faster then
before:

UPDATE forum_gtree SET gid2 = (decode(replace(gid, '\\', '\\\\'),
'escape'));

This may be because some other side effects (but it's the same machine and
same disc, same partition), but also perhaps some changes in the patch ...

MANY THANKS!

When I'm back from WSIS I make the next try to change my application from
Base255-text to bytea ;-)

Ciao
Alvar

- --
** Alvar C.H. Freude -- http://alvar.a-blast.org/ -- http://odem.org/
** Berufsverbot? http://odem.org/aktuelles/staatsanwalt.de.html
** ODEM.org-Tour: http://tour.odem.org/
** Informationsgesellschaft: http://www.wsis-koordinierungskreis.de/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (FreeBSD)

iD8DBQE/0Tg6OndlH63J86wRAiLfAJ98wLJeeyEuFXG07Pa7ba/jM7LzxQCgzWa1
RGv3FtQ8JP/MZjCWuqbdnsY=
=U9Ng
-----END PGP SIGNATURE-----