Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Rename ACCOUNT_SORTKEY() to REPORD() #182

Open
dnicolodi opened this issue Jun 15, 2024 · 0 comments
Open

Rename ACCOUNT_SORTKEY() to REPORD() #182

dnicolodi opened this issue Jun 15, 2024 · 0 comments
Labels
feature New feature

Comments

@dnicolodi
Copy link
Collaborator

Quoting TODO.md

Rename ACCOUNT_SORTKEY(), it's a terrible name. Name this REPORD() for "report order".

I'm not sure REPORD() is much better. Another option is to introduce an ACCOUNT() function that turns an account name into an account object and have account objects compare in a way that results in the desired ordering. However,

SELECT
  account,
  sum(position)
GROUP BY
  account
ORDER BY
  account(account)

does not look very nice or intuitive.

@dnicolodi dnicolodi added the feature New feature label Jun 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature New feature
Projects
None yet
Development

No branches or pull requests

1 participant