Re: Missing feature in informix?

Joe Lumbley (jlumbley@netcom.com) wrote: : Gnana1 (gnana1@aol.com) wrote: : : Informix does have this feature. : : select * from tablea where rowid > 10 and rowid < 20. : : Ravi. : Unfortunately, this will not work. Someone already mentioned the problems : if the table is fragmented across dbspaces, and someone also mentioned the : recommendations about not using rowids in 7.X and above. : The select above may or may not return rows....the rowid will be assigned : based on the internal algorithm....It does not necessarily appear in any : certain order....what happens if rowid 15 has been deleted and the space : successfully reused? : Joe : -- : --------------------------------------------------------------------------- : Joe Lumbley(jlumbley@netcom.com) : --------------------------------------------------------------------------- Another thing is that if you have nonfragmented table, the smallest possible value of rowid is 257, this is hexadecimal 0x101 - logical page 1, row 1 (logical page 0 is always bitmap page). On fragmented table with rowids rowid starts at 1. Mirek -- ================================= Miroslav Lorenc Database Administrator Software Applications and Systems Internet: Miroslav.Lorenc@sasprg.cz Tiskarska 10/257 108 28 Prague 10 Tel: +42 2 705134 Czech Republic Fax: +42 2 705128