Re: [GENERAL] Fwd: [webmaster] Update query issue

On Jan 17, 2017, at 5:33 AM, kumar s <leelaseshukumar@gmail.com

<mailto:leelaseshukumar@gmail.com>> wrote:

Hi team thanks for giving option....
I am getting update problem ...after update row thst row appended end

of the table ...i need update row without change row position if any
possible please rply .

In Postgres UPDATE is actually DELETE old row, INSERT new row so the row position will change.

Why is the new row being in a new position a problem?

to add to this, relations (tables) are considered unordered sets, if you want a specific order, use ORDER BY in your query.

-- 
john r pierce, recycling bits in santa cruz