What are the challenges you face when working across database platforms? Take the survey
Options

New formatting styles - alignment after 'where exists' incorrect

First off, thanks for the new formatting styles - they're excellent, and I'm now able to get very close to how I prefer to write SQL. However, I have noticed an issue.

I use the "right aligned to statement" clause alignment option, and I've noticed that after a 'where exists', any 'and' clauses get lined up with the word 'exists' rather than with 'where'.

This behaviour isn't replicated if you have a 'where' clause followed by an 'and exists'; in this case, the 'where' and the 'and' line up, as I would expect.
Tagged:

Comments

Sign In or Register to comment.