From c611d740c42d48690ca443df5a865478860428b6 Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Mon, 25 Sep 2023 08:14:05 +0200 Subject: feat: Refine postgres article --- content/posts/postgres-aggregates/aggregation.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'content/posts/postgres-aggregates/aggregation.sql') diff --git a/content/posts/postgres-aggregates/aggregation.sql b/content/posts/postgres-aggregates/aggregation.sql index ebb9ed5..32b08ab 100644 --- a/content/posts/postgres-aggregates/aggregation.sql +++ b/content/posts/postgres-aggregates/aggregation.sql @@ -14,7 +14,7 @@ FROM LEFT JOIN reviews ON reviews.product_id = products.id LEFT JOIN orders ON orders.product_id = products.id -- WHERE - -- products.id % 10 = 0 + -- products.name ilike '%0' GROUP BY products.id; -- cgit v1.3