23 Jun
2010
23 Jun
'10
1:32 p.m.
I have searched in the internet and found that this escape syntax is supported since
version 8.1 (released 2005-11-08).
The postgres documentation of version 8.0 describes another syntax and therefore I guess
that it was not supported.
Conclusion:
escape syntax E'' requires postgresql version >=8.1
regards
Klaus
Am 21.06.2010 21:48, schrieb Klaus Feichtinger:
--
GMX DSL: Internet-, Telefon- und Handy-Flat ab 19,99 EUR/mtl.
Bis zu 150 EUR Startguthaben inklusive! http://portal.gmx.net/de/go/dsl
Hello Klaus,
Do you know if the E'' syntax is supported in old versions too? (we
should still support older psql versions too)
klaus Can you test if this solves your problem? Just
grep for the SQL
queries (SELECT, UPDATE, INSERT, DELETE) and replace 'strings' with
E'strings'.
That's what I've already tested before. The prefix
"E" in front of the
body string helped and therefore no warning message was generated by
postgresql.