Tom Lane wrote:
>
> Keith Gray <[EMAIL PROTECTED]> writes:
> > Is it possible to get/configure PostgreSQL to handle
> > as within a dleimited string?
>
> We already do.
>
> regression=# select 'O''SHEA';
> ?column?
> --
> O'SHEA
> (1 row)
>
> regards, tom la
Keith Gray <[EMAIL PROTECTED]> writes:
> This may be a problem in "ipgsql" then??
I guess. What is that, anyway?
> ...or is it different in update from select?
Nope, a literal is a literal.
regards, tom lane
---(end of broadcast)---
Keith Gray <[EMAIL PROTECTED]> writes:
> Is it possible to get/configure PostgreSQL to handle
> as within a dleimited string?
We already do.
regression=# select 'O''SHEA';
?column?
--
O'SHEA
(1 row)
regards, tom lane
---(end of broad
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
::= '
::=
update client set code = 'O''SHEA' whe
