st 16. 1. 2019 v 9:26 odesílatel Peter Eisentraut <
peter.eisentr...@2ndquadrant.com> napsal:

> On 15/01/2019 08:18, Pavel Stehule wrote:
> > I would to have a mechanism for safe replacement of triggers of type
> >
> > if TG_TYPE = 'INSERT' THEN
> >   NEW.inserted := CURRENT_TIMESTAMP;
> > ELSE IF TG_TYPE = 'UPDATE' THEN
> >   NEW.updated := CURRENT_TIMESTAMP;
> >  ..
>
> That kind of use is probably better addressed with a temporal facility.
>

yes. I am looking for this functionality in Postgres

Pavel


> --
> Peter Eisentraut              http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>

Reply via email to