From: | hlefebvre <hlefebvre(at)lexbase(dot)net> |
---|---|
To: | Andreas Tille <tillea(at)rki(dot)de> |
Cc: | PostgreSQL SQL <pgsql-sql(at)hub(dot)org> |
Subject: | Re: Re: Date of creation and of change |
Date: | 2000-08-25 14:18:32 |
Message-ID: | 39A68038.9783106@lexbase.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Andreas Tille wrote:
>
> 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 :-(.
>
I tried...
I fact it seems that it doesn'nt work if you don't use the changedat
column in your UPDATE our insert statement. Just put null, and it will
be ok I think.
From | Date | Subject | |
---|---|---|---|
Next Message | hlefebvre | 2000-08-25 14:46:36 | Re: Re: Date of creation and of change |
Previous Message | Tom Lane | 2000-08-25 14:14:48 | Re: Re: Date of creation and of change |