| From: | Remigiusz Sokolowski <rems(at)gdansk(dot)sprint(dot)pl> |
|---|---|
| To: | Roberto Joao Lopes Garcia <roberto(at)mha(dot)com(dot)br> |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] DEFAULT TEXT 'now' in create table |
| Date: | 1999-02-15 11:12:10 |
| Message-ID: | Pine.GS4.4.02A.9902151210530.18617-100000@netra.gdansk.sprint.pl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
>
> Im making tests on datetime fields and try to use DEFAULT TEXT 'now' but
> it end up always with the same time.
>
> Is it OK? I do not think so! Perhaps I made some mistakes or do not
> understood the manuals.
>
> PostgreSQL 6.4.0 - Sparc Solaris 2.5 - front end psql
> hora time DEFAULT TEXT 'now',
Hi!
Instead of 'now' use now() this will always insert actual time - I have
teh same problem :-)
Rem
-------------------------------------------------------------------*------------
Remigiusz Sokolowski e-mail: rems(at)gdansk(dot)sprint(dot)pl * *
-----------------------------------------------------------------*****----------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jose' soares | 1999-02-15 12:07:59 | Re: [SQL] index on aggregate function |
| Previous Message | J. Kinsley | 1999-02-15 09:01:28 | ENUM Type |