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
