Re: autotimestamping

Am Mit, 2003-06-25 um 20.17 schrieb Michael Hanna:
> want an auto timestamping on my table.. SQL of create:
> create table healthnotes ( "posted" timestamptz not null default
> current_timestamp,
> "notes" text,
> primary key (posted))
>
> was succ. but how do I set it to autotimestamp when adding entries?
>
> tried:
>
> insert into healthnotes values ('my text notes entry my text notes
> entry my text notes entry')
>
> but said the value for timestamp was too long
> clearly the autotimestamp isn't set up yet

insert into healthnotes (notes) values ('my text notes entry my text
notes entry my text notes entry');

HTH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de