|
On 1/17/2017 1:04 PM, Adrian Klaver
wrote:
On Jan 17, 2017,
at 5:33 AM, kumar s <leelaseshukumar@xxxxxxxxx
<mailto:leelaseshukumar@xxxxxxxxx>>
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
|
