Re: [GENERAL] weirdness with the a sql update

2005-08-04 Thread Michael Fuhr
On Thu, Aug 04, 2005 at 09:19:44AM -0500, Tony Caduto wrote: > I just noticed this, if I do a update like this: > > update new_requests set name = 'tony' where request_id = 2 > > If I do a select * from new_requests that record I just updated is now > at the bottom , before the update it was at

Re: [GENERAL] weirdness with the a sql update

2005-08-04 Thread Sven Willenberger
On Thu, 2005-08-04 at 09:19 -0500, Tony Caduto wrote: > Hi, > > I just noticed this, if I do a update like this: > > update new_requests set name = 'tony' where request_id = 2 > > If I do a select * from new_requests that record I just updated is now > at the bottom , before the update it was a

Re: [GENERAL] weirdness with the a sql update

2005-08-04 Thread Douglas McNaught
Tony Caduto <[EMAIL PROTECTED]> writes: > Hi, > > I just noticed this, if I do a update like this: > > update new_requests set name = 'tony' where request_id = 2 > > If I do a select * from new_requests that record I just updated is now > at the bottom , before the update it was at the top? > > Wh

Re: [GENERAL] weirdness with the a sql update

2005-08-04 Thread Martijn van Oosterhout
On Thu, Aug 04, 2005 at 09:19:44AM -0500, Tony Caduto wrote: > Hi, > > I just noticed this, if I do a update like this: > > update new_requests set name = 'tony' where request_id = 2 > > If I do a select * from new_requests that record I just updated is now > at the bottom , before the update i