Basically you want to write something like:SELECT *FROM idsJOIN ( :values_clause ) vc (vid) ON (vc.vid = ids.id)or WITH vc AS (SELECT vid FROM .... ORDER BY ... LIMIT )SELECT *FROM idsJOIN vc ON (vid = ids.id)
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных