order of rows in update

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: order of rows in update
Date: 2008-09-02 09:58:36
Message-ID: 200809021258.36493.achill@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
is there an (implicit) way to make a multirow update execute on some rows prior to other rows?
It is needed in a case where a trigger is defined on the table as FOR EACH ROW, and it is mandatory
that the trigger is run for some certain rows before it is run on the rest of the rows.

Is there anything reliable to achieve this without making poor assumptions of the future
versions, or should i just "SELECT ... ORDER BY ..." and then perform individual UPDATEs?

Thanx

--
Achilleas Mantzios

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma 2008-09-02 14:24:05 Re: order of rows in update
Previous Message Gary Chambers 2008-09-01 18:36:38 Re: MAY I HAVE YOUR ASSISTANCE