WITH OrderedPosts AS (
    SELECT ROW_NUMBER() OVER (ORDER BY priority DESC NULLS LAST, created_at DESC) AS index,
           id, title, ago(created_at), priority, user_id
    FROM post
)
SELECT * FROM OrderedPosts
ORDER BY priority DESC NULLS LAST, created_at DESC;