WIP

[webmention-receiver] / src / db / postgres / sql / channel-rank-insert.sql

--
WITH next_channel_rank AS (
        SELECT COALESCE(MAX(rank) + 1, 0) AS rank
        FROM channel_rank
        WHERE channel_id = $(channelId)
)
INSERT INTO channel_rank (channel_id, rank) VALUES (
        $(channelId),
        (SELECT rank FROM next_channel_rank)
)
RETURNING *