Hi. With an integer identity primary key table,
we fetch a number of rows with WHERE id = ANY($1),
with $1 an int[] array. The API using that query must return
rows in the input int[] array order, and uses a client-side
mapping to achieve that currently.
Is it possible to maintain $1's order directly in SQL? Efficiently?
Currently the code assumes all PKs will be found. I.e. no "holes".
Would that assumption change the way it would be done in SQL?
Thanks, --DD