Hi!
-----Original Message-----
From: Tom Lane [mailto:[EMAIL PROTECTED]
> Possibly a binary cast (WITHOUT FUNCTION) would solve your problem,
> though I doubt it will work well on bytea values containing \0.
Thanks, I've been a bit thick here, but I just found the solution to my problem
- and that doesn't need this awkward function nor any type of extra WITHOUT
FUNCTION casts - just decode and encode, alas in exactly the opposite order
than I originally expected.
mypgdb=# select decode('Tübingen'::text,'escape');
decode
-----------------
T\303\274bingen
(1 row)
mypgdbe=# select encode('T\303\274bingen','escape');
encode
----------
Tübingen
(1 row)
I think this should be safe for any kind of bytea value.
Kind regards
Markus
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
