When using apostrophies the PostgreSQL string seems to like 
an escape character as follows:


        update client set code = 'O\'SHEA' where clientid = 2;


The ANSI-92 standard seems to suggest that this could/should 
be handled by 

<quote> ::= '
<quote symbol> ::= <quote><quote>

        update client set code = 'O''SHEA' where clientid = 2;


Is it possible to get/configure PostgreSQL to handle <quote><quote>
as <quote> within a dleimited string?


Keith Gray

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to