Trigger for modification timestamp column

Поиск
Список
Период
Сортировка
От Johan Andersson
Тема Trigger for modification timestamp column
Дата
Msg-id 29096359.post@talk.nabble.com
обсуждение исходный текст
Ответы Re: Trigger for modification timestamp column  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Trigger for modification timestamp column  (Susan Cassidy <scassidy@stbernard.com>)
Re: Trigger for modification timestamp column  (Michael Nolan <htfoot@gmail.com>)
Список pgsql-general
Hello!

I am trying to write a trigger for updating a modification column and am
having some trouble getting it to behave as I want.

The trigger should set the column to the supplied value if it is set in the
UPDATE statement and to the current timestamp [NOW()] if it is not. The
problem is that I don't know how to check if the column is set or not. I can
check the column's value for NULL but that doesn't work if I want the column
to accept NULL values (meaning "unmodified").

I would like something like:
CREATE FUNCTION update_modified()
    RETURNS TRIGGER AS $$
        BEGIN
            IF NOT isset(NEW.modified) THEN
                NEW.modified = NOW();
            END IF;
            RETURN NEW;
        END;
    $$ LANGUAGE 'plpgsql';

Does anyone know how to do this?

Thanks in advance!

/ Johan
--
View this message in context: http://old.nabble.com/Trigger-for-modification-timestamp-column-tp29096359p29096359.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


В списке pgsql-general по дате отправления:

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: make view with union return one record
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Trigger for modification timestamp column