Use default now()
--
Jesus Aneiros Sosa
mailto:aneiros@jagua.cfg.sld.cu
http://jagua.cfg.sld.cu/~aneiros
On Wed, 16 Aug 2000, Ang Sei Heng wrote:
> Hello to all the SQL gurus...
>
> I have this little table:
>
> test1 (
> id char(8) primary key,
> name char(20),
> create_date timestamp
> );
>
> Now, the create_date need to be updated
> to date and time whenever id is being
> inserted or updated.
>
> Is there a way in SQL that I can do this
> automatically?
>
> I try the following command using 'trigger'
>
> ----
> CREATE_TRIGGER test1_autodate
> AFTER INSERT OR UPDATE ON
> test1 FOR EACH ROW EXECUTE update("test1")
>
> CREATE FUNCTION update(char *) RETURNS int4
> AS 'UPDATE $1 set date="now"'
> LANGUAGE 'sql';
> ----
>
> But realized 'char *' is not allow... Is there a
> way to solve this?
>
> Or Am I the right track in solving this problem?
>
> Hope someone can help me... thanks.
>
> Sei Heng
>
>