Re: one more word about rules - Mailing list pgsql-general

From Zeljko Trogrlic
Subject Re: one more word about rules
Date
Msg-id 4.1.20000926114710.01685e60@192.168.0.7
Whole thread Raw
In response to Re: one more word about rules  ("Abe Asghar" <abe@fish.tm>)
List pgsql-general
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 one has 2 etc.
>
>Then I order them when they are displayed on the web reversely so that the
>last article added is at the top of the list.
>
>I now face a major problem.  If we need to back dackdate an article - I
>can't.  This is because the all the indexes are taken up ie 1, 2, 3......75
>odd records.  If I want to add one between 50 and 51 ie 50.5, I cannot
>because the field is an int4.
>
>One idea I had to get around this was to create a new table with this column
>as a float and read and write all therecords in with a PHP script.
>
>Is there an easier way such as converting the column data type from a int4
>to a float.
>
>Thanks in advance.
>Abe.



pgsql-general by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: FreeBSD Softupdates??
Next
From: Jose Manuel Lorenzo Lopez
Date:
Subject: PGresult deleted after PQfinish(PGconn)