From 9ec0f384c5871ab3452834a9552f58223a7f0b7b Mon Sep 17 00:00:00 2001 From: Ngô Ngọc Đức Huy Date: Tue, 23 Apr 2024 22:07:40 +0700 Subject: Fix styling --- content/posts/2024-01-05-mayim-sqlite.md | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'content') diff --git a/content/posts/2024-01-05-mayim-sqlite.md b/content/posts/2024-01-05-mayim-sqlite.md index a151bfe..d20c1f0 100644 --- a/content/posts/2024-01-05-mayim-sqlite.md +++ b/content/posts/2024-01-05-mayim-sqlite.md @@ -169,7 +169,8 @@ I'm skipping a bit here because categories has only one data field, though I probably should write full objects as for prices. ```sql -SELECT product.id, product.name, json_group_array(category.name) as categories, json_group_array( +SELECT product.id, product.name, json_group_array(category.name) as categories, +json_group_array( json_object('id', price.id, 'price', price, 'unit', unit) ) as prices FROM product -- cgit 1.4.1