0

so I'm trying to do a query that fetches a certain id first.

i know the sql syntax is something along the lines of -

SELECT id, name, colour
FROM books
ORDER BY id=2 desc;

i am trying to figure out how to do the same thing in a postgraphile query with pagination

thank you very much!

sandy mashinsky
  • 1
  • too wide question, follow some tutorial – xadm Jul 28 '20 at 15:38
  • PostGraphile maintainer here; never had this request before! Simplest solution is a custom query: https://www.graphile.org/postgraphile/custom-queries/ – Benjie Jul 28 '20 at 16:49

0 Answers0