Re: Read-only column

Il ven, 2003-12-12 alle 20:11, Doug McNaught ha scritto:
> Claudio Succa <claudio(dot)succa(dot)ml(at)pertel(dot)it> writes:
>
> > Given a table like the following:
> >
> > CREATE TABLE mytable (
> > progr integer PRIMARY KEY,
> > record_creation_date date DEFAULT current_date,
> > ...
> > other columns
> > ...
> > );
> >
> > is there a way to deny any modifications to 'record_creation_date'
> > without using a view?
>
> Sure, you can use a trigger.
>
> -Doug

Thanks a lot Doug.

(Not to reinvent the wheel, do you know where I could find a suitable
function to use in the trigger?)

Claudio

--
Claudio Succa
PERTEL - Torino - Italy
+39-011-437.4141
http://www.pertel.it
http://www.uniassist.it