On 1/17/2017 1:04 PM, Adrian Klaver wrote:
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