Re: one more word about rules

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.