Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] DEFAULT TEXT 'now' in create table - Mailing list pgsql-sql

From Remigiusz Sokolowski
Subject Re: [SQL] DEFAULT TEXT 'now' in create table
Date
Msg-id Pine.GS4.4.02A.9902151210530.18617-100000@netra.gdansk.sprint.pl
Whole thread Raw
In response to DEFAULT TEXT 'now' in create table  (Roberto Joao Lopes Garcia <roberto@mha.com.br>)
List pgsql-sql
Tree view 
>
> I�m 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@gdansk.sprint.pl           * *
-----------------------------------------------------------------*****----------

pgsql-sql by date:

Previous
From: "J. Kinsley"
Date:
Subject: ENUM Type
Next
From: "jose' soares"
Date:
Subject: Re: [SQL] index on aggregate function