From 7bbc065f4176c6e36bb2d7976e83d1b692274921 Mon Sep 17 00:00:00 2001
From: Paul Duncan <pabs@pablotron.org>
Date: Thu, 17 Feb 2022 19:59:56 -0500
Subject: TODO.md: add pg tricks

---
 TODO.md | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/TODO.md b/TODO.md
index c330e3d..bf9d5ab 100644
--- a/TODO.md
+++ b/TODO.md
@@ -136,3 +136,13 @@ this stuff may not make any sense.
   https://forums.somethingawful.com/showthread.php?noseen=0&threadid=2389159&perpage=40&pagenumber=865#post520151251
   https://nathanotterness.com/2021/10/tiny_elf_modernized.html
   (created repo: https://github.com/pablotron/tiny-binaries)
+* pg tiny tricks
+  - CTEs as optimization barrier:
+    https://old.reddit.com/r/programming/comments/suyidt/a_hairy_postgresql_incident/hxdvwl4/
+  - `~* ANY(string_to_array(?))` (comment in reddit w/json array)
+  - pub/sub?
+  - domains instead of repeated check constraints
+  - trigger `TG_ARGV`
+  - trigger `REFERENCING ... AS` (newer PG)
+  - `COMMENT ON` ...
+  - `LISTEN/NOTIFY`?
-- 
cgit v1.2.3