aboutsummaryrefslogtreecommitdiff
path: root/content/posts/postgres-aggregates/merging-ctes.sql
diff options
context:
space:
mode:
authorMartin Kagamino Lehoux <martin@lehoux.net>2023-09-25 08:14:05 +0200
committerMartin Kagamino Lehoux <martin@lehoux.net>2023-09-25 08:14:05 +0200
commitc611d740c42d48690ca443df5a865478860428b6 (patch)
tree526952011e421ce0e804b56c9fb739859dd6933c /content/posts/postgres-aggregates/merging-ctes.sql
parent20219dd4f7192c61492b7667dd3f15b05dbba044 (diff)
feat: Refine postgres article
Diffstat (limited to 'content/posts/postgres-aggregates/merging-ctes.sql')
-rw-r--r--content/posts/postgres-aggregates/merging-ctes.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/content/posts/postgres-aggregates/merging-ctes.sql b/content/posts/postgres-aggregates/merging-ctes.sql
index 2061efd..4bce527 100644
--- a/content/posts/postgres-aggregates/merging-ctes.sql
+++ b/content/posts/postgres-aggregates/merging-ctes.sql
@@ -31,4 +31,4 @@ FROM
LEFT JOIN product_orders ON products.id = product_orders.product_id;
-- WHERE
--- products.id % 10 = 0
+-- products.name ilike '%0'