From c611d740c42d48690ca443df5a865478860428b6 Mon Sep 17 00:00:00 2001
From: Martin Kagamino Lehoux <martin@lehoux.net>
Date: Mon, 25 Sep 2023 08:14:05 +0200
Subject: feat: Refine postgres article

---
 content/posts/postgres-aggregates/sequential-ctes.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'content/posts/postgres-aggregates/sequential-ctes.sql')

diff --git a/content/posts/postgres-aggregates/sequential-ctes.sql b/content/posts/postgres-aggregates/sequential-ctes.sql
index fa18acd..825649e 100644
--- a/content/posts/postgres-aggregates/sequential-ctes.sql
+++ b/content/posts/postgres-aggregates/sequential-ctes.sql
@@ -8,7 +8,7 @@ WITH product_with_reviews AS (
     products
     LEFT JOIN reviews ON reviews.product_id = products.id
     -- WHERE
-    --   products.id % 10 = 0
+    --   products.name ilike '%0'
   GROUP BY
     products.id,
     products.name
-- 
cgit v1.3