but this will be in 7.5, not 7.4, won't it?
Andrew Dunstan wrote:
----- Original Message ----- From: "Hannu Krosing" <[EMAIL PROTECTED]>
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.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org