ID shouldn't contain any additional informations (like order). It's ID. Use
another field for sorting.
At 16:33 22.9.2000 , Abe Asghar wrote:
>Hi everyone,
>
>I have built a database that uses int4 as the unique identifier for a news
>database.
>
>Therefore an article has a identifier 1, the next
a database that contains articles
> that I need that I am going to move to the new table.
>
> Abe.
> - Original Message -
> From: "John McKown" <[EMAIL PROTECTED]>
> To: "Abe Asghar" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
>
On Fri, Sep 22, 2000 at 03:33:46PM +0100, Abe Asghar wrote:
> Hi everyone,
>
> I have built a database that uses int4 as the unique identifier for a news
> database.
>
> Therefore an article has a identifier 1, the next one has 2 etc.
>
> Then I order them when they are displayed on the web rev
Abe,
How do you generate your article number? If you are using a SERIAL, then
you could change it to use a specific SEQUENCE and step the SEQUENCE by
some value other than one. Something like:
CREATE SEQUENCE article_sequence INCREMENT 100 MINVALUE 1 START 101;
CREATE TABLE article (
article_num
