Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Sql > Re: After updat...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 12 Topic 3425 of 3717
Post > Topic >>

Re: After updating dataset the record goes to the end of the dataset

by depesz@[EMAIL PROTECTED] (hubert depesz lubaczewski) Apr 22, 2008 at 12:15 PM

On Tue, Apr 22, 2008 at 12:10:41PM +0200, Nacef LABIDI wrote:
> Yes I don't issue any sort statement, and I indeed want the data to be
show
> as it is stored in the database. But after updating a row (I don't
update
> the ID, just some fields), it keeps its same place on the DB but jumps
to
> the end of the dataset and by the way to the end of the DBGrid.

why do you think it stays in the same place in db?

besides - without "order by" you cannot depend on the order of rows.
basically i treat them as in "random" order (which is not true, but
helps me remember to never count on the "default" ordering.

depesz

-- 
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/
- blog dla ciebie (i moje CV)

-- 
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
 




 12 Posts in Topic:
After updating dataset the record goes to the end of the dataset
nacef.l@[EMAIL PROTECTED]  2008-04-22 11:54:26 
Re: After updating dataset the record goes to the end of the dat
nacef.l@[EMAIL PROTECTED]  2008-04-22 12:10:41 
Re: After updating dataset the record goes to the end of the dat
depesz@[EMAIL PROTECTED]   2008-04-22 12:15:23 
Re: After updating dataset the record goes to the end of the
craig@[EMAIL PROTECTED]   2008-04-22 20:46:30 
Re: After updating dataset the record goes to the end of the dat
spam_eater@[EMAIL PROTECT  2008-04-22 12:11:42 
Re: After updating dataset the record goes to the end of the dat
singh.gurjeet@[EMAIL PROT  2008-04-22 15:42:37 
Re: After updating dataset the record goes to the end of the dat
nacef.l@[EMAIL PROTECTED]  2008-04-22 12:31:54 
Re: After updating dataset the record goes to the end of the dat
depesz@[EMAIL PROTECTED]   2008-04-22 13:02:14 
Re: After updating dataset the record goes to the end of the
padam.singh@[EMAIL PROTEC  2008-04-22 16:32:57 
Re: After updating dataset the record goes to the end of the dat
pavan.deolasee@[EMAIL PRO  2008-04-22 16:15:10 
Re: After updating dataset the record goes to the end of thedata
nacef.l@[EMAIL PROTECTED]  2008-04-22 15:00:21 
Re: After updating dataset the record goes to the end of thedata
scott.marlowe@[EMAIL PROT  2008-04-22 09:16:44 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Oct 12 14:21:51 CDT 2008.