diff options
| author | Martin Kagamino Lehoux <martin@lehoux.net> | 2023-09-25 08:14:05 +0200 |
|---|---|---|
| committer | Martin Kagamino Lehoux <martin@lehoux.net> | 2023-09-25 08:14:05 +0200 |
| commit | c611d740c42d48690ca443df5a865478860428b6 (patch) | |
| tree | 526952011e421ce0e804b56c9fb739859dd6933c /content/posts/postgres-aggregates/sequential-ctes.sql | |
| parent | 20219dd4f7192c61492b7667dd3f15b05dbba044 (diff) | |
feat: Refine postgres article
Diffstat (limited to 'content/posts/postgres-aggregates/sequential-ctes.sql')
| -rw-r--r-- | content/posts/postgres-aggregates/sequential-ctes.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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 |