Return rows in input array's order?

[Dominique Devienne <ddevienne@xxxxxxxxx>]

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