Re: [GENERAL] Numbering a records

2004-02-18 Thread Richard Huxton
On Wednesday 18 February 2004 12:56, NTPT wrote: > I have this table > > content (id int8,owner int8,position int8,timestamp int8,description > text,batch int8) > > Table is inserted/deleted frequently, 'id' is almoust random. > > I insert to the table following set of rows : > > 12345, 1000,1,tim

[GENERAL] Numbering a records

2004-02-18 Thread NTPT
I have this table content (id int8,owner int8,position int8,timestamp int8,description text,batch int8) Table is inserted/deleted frequently, 'id' is almoust random. I insert to the table following set of rows : 12345, 1000,1,timestamp,blabla,0 12349, 1000,2,timestamp,blabla,0 12355, 1001,