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

Поиск
Список
Период
Сортировка
Искать
От
Marcus Engene
Тема
External ordered set of id:s, want to preserve order
Дата
Msg-id
4EEB7C69.5020406@engene.se
Список
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


В списке pgsql-novice по дате отправления
От: Aleksej Trofimov
Дата:
От: Jean-Yves F. Barbier
Дата:
Сообщение: Re: type list
FAQ