Re: Using backslash in query

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: "PostgreSQL Hackers Mailing List" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Using backslash in query
Date: 2003-10-04 11:31:21
Message-ID: 004201c38a6b$0a888a00$6401a8c0@DUNSLANE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2003-10-04 12:09:03 Re: Using backslash in query
Previous Message Christopher Kings-Lynne 2003-10-04 09:38:39 Re: Weird locking situation