Row_number() formatting issue
Formatting for rownumber() seems to have issues with breaking up the line. I don't know if the parser is evaluating it as a possible subquery, but it would be great to have the option for a single line or wrapped line rownumber(). A row_number() statement on 4-5 lines seems to be a little confusing.
![](https://secure.gravatar.com/avatar/d1f3a28af2a27cd30cc7fbbe47cc57b8?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
Could you please provide us a concrete example demonstrating this and describe it in more detail?
-
AdminDevart (_, Devart) commented
row_number() with order by statement seems to be following the select/order by line break logic. Most folks I've seen online use the same single line syntax for most row_number operations. I'd like the option to customer the row_number() formatting in a select statement, maybe to allow wrapping when certain length exceeded.
-
Sheldon commented
I'm getting erratic results on this. Looks like maybe the latest update fixed? Please close and I'll repost the issue if it occurs again.
thanks!