diff options
| author | kartofen <mladenovnasko0@gmail.com> | 2022-10-24 22:33:47 +0300 |
|---|---|---|
| committer | kartofen <mladenovnasko0@gmail.com> | 2022-10-24 22:33:47 +0300 |
| commit | d4623316147306fa56e7a5317ea608dff975eb6d (patch) | |
| tree | 1d8fcb8c7cd87e7d1a0190bc191e04d6332e0d6e /src/database/postgres.ts | |
| parent | 001f07780c7dca212fb19edaab30f6068eb2c97b (diff) | |
works very good
Diffstat (limited to 'src/database/postgres.ts')
| -rw-r--r-- | src/database/postgres.ts | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/database/postgres.ts b/src/database/postgres.ts index 677a106..9ea65dc 100644 --- a/src/database/postgres.ts +++ b/src/database/postgres.ts @@ -132,7 +132,7 @@ with thread_comments as ( ) as comment from ${board}.comment c ) -select t.*, COALESCE(c.comment, '[]'::jsonb) as comment +select t.*, COALESCE(c.comment, '[]'::jsonb) as comments from ${board}.thread t left join thread_comments c on (c.tid = t.id) where t.id = ${tid};`; |