Postgres Query
From Dontopedia, the open, paraconsistent wiki. (Last updated 2026-06-06.)
Postgres Query has 14 facts recorded in Dontopedia across 2 references, with 1 live disagreement.
Mostly:selects columns(4), uses postgres(1), filters by content ilike(1)
Maturity scale
raw canonical shape-checked rule-derived certifiedOther facts (14)
The long tail: predicates that appear too rarely to warrant their own section. Filter or scroll to find a specific one. Each row links to its source.
| Predicate | Value | Ref |
|---|---|---|
| Selects Columns | Id Column | [1] |
| Selects Columns | Message Content Column | [1] |
| Selects Columns | Username Column | [1] |
| Selects Columns | Channel Id Column | [1] |
| Uses Postgres | Postgresql | [1] |
| Filters by Content Ilike | %looking for work% | [1] |
| Filters by Channel Name | general | [1] |
| Limits to | 10 | [1] |
| Orders by | timestamp DESC | [1] |
| Searches for Job Seekers | Job Seeker Messages | [1] |
| Rdf:type | Sql Query | [2] |
| Has Query String | SELECT user_id, username, COUNT(*) AS message_count, MAX(timestamp) AS last_message FROM messages GROUP BY user_id, username ORDER BY message_count DESC LIMIT 50 | [2] |
| Targets Table | Messages Table | [2] |
| Returns Field | user_id | [2] |
Timeline
Timeline axis is valid_time — when each source says the fact was true in the world, not when Dontopedia learned about it. Retracted rows are kept for provenance; coloured stripes indicate the context kind.
References (2)
ctx:discord/blah/omega/part-969ctx:discord/blah/omega/949- full textomega-949text/plain2 KB
doc:agent/omega-949/a8e87486-a3d0-4273-b24b-d220c6336bd1Show excerpt
[2026-01-21 05:10] omega [bot]: 🔧 1/2: postgresQueryExecutor ✅ Success **Args:** ```json { "query": "SELECT user_id, username, COUNT(*) AS message_count, MAX(timestamp) AS last_message FROM messages GROUP BY user_id, username ORDER BY mes…
See also
Keep researching
Missing something or suspicious of what's here? Kick off a research session — a Claude agent will investigate, cite its sources, and file new facts into a dedicated context you can review before accepting into the shared view.