[SQL] Re: Date of creation and of change

[Andreas Tille]

On Fri, 25 Aug 2000, hlefebvre wrote:

> No I suppose that the problem is the identifier "changedat" is unknown.
> 
> You must probably prefix it : NEW.changedat
> 
>  CREATE FUNCTION changed_at_timestamp() RETURNS OPAQUE AS '
>      BEGIN
>          NEW.ChangedAt := timestamp(''now'');
>          RETURN NEW;
>      END;
>  ' LANGUAGE 'plpgsql';
> 
> I didn't test it, but as pgSQL looks like Oracle, it should be ok :-)
This avoids the error message, but doesn't have any effect to the value
of ChangedAt.  It just remains the same as CreatedAt :-(.

Kind regards

         Andreas.