RE: [SQL] Default timestamp value

2000-06-05 Thread Rob S.
Thanks very much everyone! > BTW, this *is* covered in the FAQ, see > http://www.postgresql.org/docs/faq-english.html#4.22 Ahh, but I did look at a FAQ! I just went back and checked the date, I guess I shouldn't have just skimmed down the page: Last updated: Mon Oct 14 08:05:23 EDT 1996.

Re: [SQL] Default timestamp value

2000-06-05 Thread Jeff Hoffmann
Tom Lane wrote: > > "Rob S." <[EMAIL PROTECTED]> writes: > > ...but I still don't see how to have the default value of a timestamp to be > > the time at which the individual record is inserted. I just get the time I > > created the table. > Versions before 7.0 are not entirely consistent abou

Re: [SQL] Default timestamp value

2000-06-05 Thread Tom Lane
"Rob S." <[EMAIL PROTECTED]> writes: > ...but I still don't see how to have the default value of a timestamp to be > the time at which the individual record is inserted. I just get the time I > created the table. Specifically, what to put where the '?' is at. > ... "TimeDate" TIMESTAMP DEFAULT

Re: [SQL] Default timestamp value

2000-06-05 Thread Thomas Behr
"Rob S." wrote: > > As a precursor to this question, I read: > > CREATE TABLE > Date/Time Types (and corresponding input/output) > Date/Time Functions > > ...but I still don't see how to have the default value of a timestamp to be > the time at which the individual recor