diff options
| author | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-10-12 00:26:17 +0200 |
|---|---|---|
| committer | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-10-12 00:26:17 +0200 |
| commit | 5fe93e048c3f529c80d2d1adb1e49eafebc1af3c (patch) | |
| tree | 6cfaa78bc78403d1f913d342cc4625290ae9be3f /sql | |
| parent | b46012f212a4302b4d1325d8fdf9634e7083e76a (diff) | |
| download | gosten-5fe93e048c3f529c80d2d1adb1e49eafebc1af3c.tar.gz gosten-5fe93e048c3f529c80d2d1adb1e49eafebc1af3c.tar.bz2 gosten-5fe93e048c3f529c80d2d1adb1e49eafebc1af3c.zip | |
Sort categories on loading
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/categories.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/sql/categories.sql b/sql/categories.sql index 2c8e5c7..e7d9579 100644 --- a/sql/categories.sql +++ b/sql/categories.sql @@ -1,4 +1,5 @@ --- name: GetCategories :many +-- name: GetCategoriesOrdered :many SELECT id, name FROM categories - WHERE user_id = $1;
\ No newline at end of file + WHERE user_id = $1 + ORDER BY name ASC;
\ No newline at end of file |