yancya · November 16, 2017 05:26
diff --git a/card.sql b/card.sql
    WITH local_card_ids(id, "order") AS (VALUES(1, 0), (2, 1), (3, 2), (4, 3), (5, 4))
  SELECT cache.cards.*
    FROM cache.cards
    JOIN local_card_ids USING(id)
 ORDER BY local_card_ids."order";
	WITH local_card_ids(id, "order") AS (VALUES(1, 0), (2, 1), (3, 2), (4, 3), (5, 4))
	SELECT cache.cards.*
	FROM cache.cards
	JOIN local_card_ids USING(id)
	ORDER BY local_card_ids."order";