diff options
| author | Ngô Ngọc Đức Huy <huyngo@disroot.org> | 2024-04-23 22:07:40 +0700 |
|---|---|---|
| committer | Ngô Ngọc Đức Huy <huyngo@disroot.org> | 2024-04-23 22:13:38 +0700 |
| commit | 9ec0f384c5871ab3452834a9552f58223a7f0b7b (patch) | |
| tree | 7a9c801149ab0213eca91c1ecc85379eb0654598 /content | |
| parent | 40f57ed72a601d8489a180f3bd9acd5e6c20d323 (diff) | |
| download | blog-9ec0f384c5871ab3452834a9552f58223a7f0b7b.tar.gz | |
Fix styling
Diffstat (limited to 'content')
| -rw-r--r-- | content/posts/2024-01-05-mayim-sqlite.md | 3 |
1 files changed, 2 insertions, 1 deletions
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 |