From 5fe93e048c3f529c80d2d1adb1e49eafebc1af3c Mon Sep 17 00:00:00 2001 From: René 'Necoro' Neumann Date: Sat, 12 Oct 2024 00:26:17 +0200 Subject: Sort categories on loading --- sql/categories.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'sql/categories.sql') 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 -- cgit v1.2.3-70-g09d2