Re: [ADMIN] Data out of alignment?

1999-08-12 Thread Aaron Seigo
hi.. >table. Could that cause it to shift like that. Normall we select this by >no order. Is it safe to select it by the oidas in the oid will NOT >change, even though the order in the database is shifting? according to my experience (and i just double checked it on our 6.5 installation =

RE: [ADMIN] Data out of alignment?

1999-08-12 Thread Greg Youngblood
First let me start out by saying I have not looked at the Postgres source, thus this is pure speculation until confirmed by someone who knows for sure. If you store data in a btree type of format (which I believe is how Postgres stores data, or at least indexes) and then you perform a full query

[ADMIN] Data out of alignment?

1999-08-12 Thread Darren Greer
Hello all. Often times in our database we have web pages built off of the order in which data is retrieved from the database. For the most part this data is retreived in the same order in which it was put in. For Example we put in the following info song1, title2 song2, title2 song3, title3 E