External ordered set of id:s, want to preserve order - Mailing list pgsql-novice

From Marcus Engene
Subject External ordered set of id:s, want to preserve order
Date
Msg-id 4EEB7C69.5020406@engene.se
Whole thread Raw
List pgsql-novice
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 by date:

Previous
From: Aleksej Trofimov
Date:
Subject: Re: question re incrementing an integer field in a table.
Next
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: type list