News for hackers. Stuff that matters.

A comment on Black, the uncompromising Python code formatter, is stable. Parent comment

Re:Black, the uncompromising Python code formatter, is stable by JackFr on Saturday January 29, 2022 @04:39PM (#30130796)
When you’re embedding SQL in a string, a you use ‘ a lot more than “. Not the only use case, but one to give some consideration.
[ Parent | on HN ]
Re:Black, the uncompromising Python code formatter, is stable by throwaway894345 on Saturday January 29, 2022 @05:10PM (#30131084)
I think that’s only MySQL. Postgres uses double quotes for identifiers and single quotes for literals.

EDIT: I misinterpreted that single quote as a backtick. In any case, both single and double quotes are common in SQL, but single quotes are a bit more common.

[ Parent | on HN ]