Postgres Pro
Downloads
Home   >   mailing lists

Re: Use ctid in where clause in update from statement - Mailing list pgsql-general

From Dirk Mika
Subject Re: Use ctid in where clause in update from statement
Date
Msg-id C5E06016-DACB-4EE4-BAF6-D6F6F084867F@mikatiming.de
Whole thread Raw
In response to Re: Use ctid in where clause in update from statement  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view 
Hi

    Thinking about it, it _has_ to call any BEFORE trigger function
    as that might change values of the row to be inserted that
    could possibly change the outcome of the test.

Yeah, that was my thought, too. Unfortunately, the affected trigger changes two columns, so I can't change it to an
AFTERROW trigger.
 

Dirk







--
Dirk Mika
Software Developer

mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany

fon +49 2202 2401-1197
dirk.mika@mikatiming.de
www.mikatiming.de

AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika



## How2Use
## the ChampionChip by mika:timing
## https://youtu.be/qfOFXrpSKLQ

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Use ctid in where clause in update from statement
Next
From: Tom Lane
Date:
Subject: Re: Use ctid in where clause in update from statement