Thread: External ordered set of id:s, want to preserve order

External ordered set of id:s, want to preserve order

From
Marcus Engene
Date:
Hi list,

I have a website where I use solr for Full Text Search and receive an
ordered list of
integers that are id:s for a postgres table.

create table the_table
(
  id SERIAL PRIMARY KEY NOT NULL
,data text
);

It would be nice to maintain this order when selecting in the postgres
table. What would be
the most efficient way to do that?

Thanks,
Marcus