"Ken J. Wright" ha scritto:
> You have to preceed each occurence of ' with a \.
> So "test'string" becomes "test\'string".
>
SQL92 says that you have to use the ' twice. If you want to write portable
code, then:
INSERT INTO table1 VALUES('WHAT''S THAT ?');
and it becomes: WHAT'S THAT ?.
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'