----- 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.
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
