Re: [BUGS] bytea, index and like operator

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, - -- Joe Conway <[EMAIL PROTECTED]> wrote: > Note that bytea input strings should be escaped with doubled backslashes, > because the string literal parser consumes 1 layer, and the byteain > function consumes another. See: > http://www.postgresql

Re: [BUGS] bytea, index and like operator

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, - -- Alvar Freude <[EMAIL PROTECTED]> 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

Re: [BUGS] bytea, index and like operator

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, - -- Joe Conway <[EMAIL PROTECTED]> wrote: > > Note that bytea input strings should be escaped with doubled backslashes, > because the string literal parser consumes 1 layer, and the byteain > function consumes another. See: > http://www.postgre

[BUGS] bytea, index and like operator

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, 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 ... ;-) When an index scan is active, a query dosn't give the correct result: select version(