Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group