----- 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.


cheers

andrew

In response to

• Re: Using backslash in query at 2003-10-04 08:20:09 from Hannu Krosing

Responses

• Re: Using backslash in query at 2003-10-04 12:09:03 from Andrew Dunstan

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