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

From: Marcus Engene <mengpg2(at)engene(dot)se>
To: pgsql-novice(at)postgresql(dot)org
Subject: External ordered set of id:s, want to preserve order
Date: 2011-12-16 17:14:17
Message-ID: 4EEB7C69.5020406@engene.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Jean-Yves F. Barbier 2011-12-18 16:43:34 Re: type list
Previous Message Aleksej Trofimov 2011-12-16 11:26:26 Re: question re incrementing an integer field in a table.