Re: bytea, index and like operator - Mailing list pgsql-bugs

From Alvar Freude
Subject Re: bytea, index and like operator
Date
Msg-id 1925690000.1070492341@gnarzelwicht.delirium-arts.de
Whole thread Raw
In response to bytea, index and like operator  (Alvar Freude <alvar@a-blast.org>)
List pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

- -- Alvar Freude <alvar@a-blast.org> wrote:

> there is a bug in handling bytea columns with index and the like-operator.
> At least in 7.3.4. When the FreeBSD Port for 7.4 is ready, I'll test this
> ... ;-)

sorry, shame on me: I have to put two \ in the query (and inserts) for
bytea.

But it's interesting that without and with index search the handling of
wrong data is different ... :)


Ciao
  Alvar

- --
** Alvar C.H. Freude -- http://alvar.a-blast.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/zmq2OndlH63J86wRAsUvAJ9pTFwNNQAsG5cNXGdUcTwmkpIjeQCeNldH
aJuVsiY2juZqrG73VeSERdc=
=NJ6+
-----END PGP SIGNATURE-----

pgsql-bugs by date:

Previous
From: Alvar Freude
Date:
Subject: Re: bytea, index and like operator
Next
From: Peter Eisentraut
Date:
Subject: Re: Conflicts with autoconf macroses