| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | kumar s <leelaseshukumar(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Fwd: [webmaster] Update query issue |
| Date: | 2017-01-17 21:28:40 |
| Message-ID: | ce718a7b-7d03-513d-20bf-2b42cc6f33ef@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 1/17/2017 1:04 PM, Adrian Klaver wrote:
>>> On Jan 17, 2017, at 5:33 AM, kumar s <leelaseshukumar(at)gmail(dot)com
>> <mailto:leelaseshukumar(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2017-01-17 22:21:15 | Re: Queries are taking way longer in 9.6 than 9.5 |
| Previous Message | Adrian Klaver | 2017-01-17 21:04:48 | Re: Fwd: [webmaster] Update query issue |