[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Strings: double versus single quotes

On 24/05/20 8:39 AM, Skip Montanaro wrote:
>> May I ask why not simply like this:
>> stmt = """
>>        select foo from bar
>>          where a = 'bag'
>>            and c = 'dog'
>>        """
> Sorry, I don't recall. I wouldn't be at all surprised that it has something
> to do with Emacs's Python mode behavior. Emacs wouldn't know what to do
> with spaces in the string, but knows where to put string literals within
> the open parens. I'm pretty sure I was doing this before triple quoted
> strings existed.
> Thankfully, I don't need to mess around with SQL anymore. :-)

Awwww. don't be like that - send it all to me, and I'll fix it for you 
(at exorbitant rates, of course)...

The above is valid - the editor has a file in one format/language, and 
is therefore applying 'the wrong rules' when it attempts to make SQL 
look like Python!

The inconvenience (cf "issue") that arises, is that many SQL debuggers 
and error-handlers (etc) will repeat-back the source-code/query 
as-provided. Consequently, those messages are all messed-up with 
extraneous tabs and new-lines, making them difficult to read and debug.
(see also: earlier post mentioning separation of languages/code)
Regards =dn