Re: SQL syntax highlightning don't work for single backslash '\'

From: Melvin Davidson <melvin6925(at)yahoo(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "mammoth(dot)power(at)gmx(dot)us" <mammoth(dot)power(at)gmx(dot)us>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: SQL syntax highlightning don't work for single backslash '\'
Date: 2017-05-22 20:02:49
Message-ID: 980375793.4335317.1495483369454@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

>Unless you omit the E prefix on the string literal, which the OP did.
Nope! That results in 'a//b' but the op wants 'a/b';
Hence the need to Escape.

Melvin Davidson 🎸
    Cell 720-320-0155
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com

From: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Melvin Davidson <melvin6925(at)yahoo(dot)com>
Cc: "mammoth(dot)power(at)gmx(dot)us" <mammoth(dot)power(at)gmx(dot)us>; "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Sent: Monday, May 22, 2017 3:54 PM
Subject: Re: [pgadmin-support] SQL syntax highlightning don't work for single backslash '\'

On Monday, May 22, 2017, Melvin Davidson <melvin6925(at)yahoo(dot)com> wrote:

>When I have somewhere in text value single backslash char, then everything behind this char will not be highlighted correct.
That is because the Backslash is an ESCAPE character, so you must ESCAPE it and use two backslashes if you want it to be interpretedas a literal.

Unless you omit the E prefix on the string literal, which the OP did.
David J.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2017-05-22 20:45:19 Re: Popup message always that PgAdmin 3 starts
Previous Message David G. Johnston 2017-05-22 19:54:09 Re: SQL syntax highlightning don't work for single backslash '\'