| From: | Alvar Freude <alvar(at)a-blast(dot)org> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: bytea, index and like operator |
| Date: | 2003-12-03 21:26:40 |
| Message-ID: | 1865030000.1070486800@gnarzelwicht.delirium-arts.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
- -- Joe Conway <mail(at)joeconway(dot)com> 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.org/docs/7.3/static/datatype-binary.html
oh, shi.... -- Yes, I read this, but forgot it ... ;-(
So, yes, you are right.
Hmmm, there are a lot of pitfalls with bytea, *puh*!
Sorry for confusion!
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/zlUROndlH63J86wRArzBAKDC8hXj0GLZrIFlaaIQBt8pk4yi3gCcCDxy
kVnHzc3mklt6/8IcI6ZvD38=
=yUYU
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-12-03 22:06:46 | Re: Misplaced modifier in Postgresql license |
| Previous Message | Joe Conway | 2003-12-03 21:08:41 | Re: bytea, index and like operator |