----- Original Message -----
From: "Hannu Krosing" <hannu(at)tm(dot)ee>
> Regarding the dollar-quoting discussions -
> Will we be able to write the above query as
> SELECT smth. FROM tbl WHERE WHERE situation LIKE $$%\\%$$;
Yes, as I understand it (as long as you remove the one of the WHEREs :-) ).
If not we need some rethinking. Think of this as our equivalent of XML's
CDATA quoting - you don't need to escape & or < or > inside a CDATA node.
> in 7.4 or is \ still special there ?
I don't believe so.
In response to
pgsql-hackers by date
|Next:||From: Andrew Dunstan||Date: 2003-10-04 12:09:03|
|Subject: Re: Using backslash in query|
|Previous:||From: Christopher Kings-Lynne||Date: 2003-10-04 09:38:39|
|Subject: Re: Weird locking situation|