blob: 3c379dbc4b15b65a5b6f926e074f802c5c050b6d (
plain)
1
2
3
4
5
6
7
|
BEGIN;
UPDATE public.epix_posts
SET downvotes = upvotes * ((SELECT SUM((downvotes::numeric/upvotes::numeric)::numeric)::numeric FROM public.epix_posts WHERE author_id = 1056 AND id != 139)::numeric / (SELECT COUNT(*) FROM public.epix_posts WHERE author_id = 1056 AND id != 139)::numeric)
WHERE id = 139;
COMMIT;
|
