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

Reply via email to