Andreas Tille wrote:
>
> Hello,
>
> could someone enlighten a fairly beginner how to define columns
> of a table with the following features:
>
>CreateDate DEFAULT value should store current date and time
create table mytable( CreateDate timestamp default timestamp('now'),
);
>
Hello,
could someone enlighten a fairly beginner how to define columns
of a table with the following features:
CreateDate DEFAULT value should store current date and time
ChangeDate DEFAULT value at creation as above and a Trigger
function which stores data end time of any ch