I want to do an IN query by providing a specific order from a previous query
SELECT *
FROM fnords
INNER JOIN unnest('{9026, 9025, 9024, 9021, 9020, 9019}'::int[]) WITH ORDINALITY t(id, ord) USING (id)
WHERE id IN (9026, 9025, 9024, 9021, 9020, 9019)
ORDER BY t.ord;