Differences From Artifact [0fea8fa8b6]:
- File backend/schema/pgsql-views.sql — part of check-in [00a6815988] at 2021-01-10 11:17:29 on branch trunk — add follow notices (user: lexi, size: 6520) [annotate] [blame] [check-ins using]
To Artifact [ac2cb76c4f]:
- File backend/schema/pgsql-views.sql — part of check-in [1ba4bbc92f] at 2021-01-11 23:33:55 on branch trunk — various cleanups, notices no longer originated from self (user: lexi, size: 6556) [annotate] [blame] [check-ins using]
226 226 from parsav_rels as r 227 227 left join ntimes as nt on nt.uid = r.relatee 228 228 where 229 229 r.since >= coalesce(nt.when,0) and 230 230 r.kind = <rel:follow> 231 231 ), allnotices as (table acts union table replies union table follows) 232 232 233 - table allnotices order by (notice).when desc 233 + select * from allnotices where rcpt <> (notice).who 234 + order by (notice).when desc 234 235 ); 235 236