Lists: | pgsql-sql |
---|
From: | Roberto Joao Lopes Garcia <roberto(at)mha(dot)com(dot)br> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | DEFAULT TEXT 'now' in create table |
Date: | 1999-02-12 16:20:46 |
Message-ID: | 3.0.5.32.19990212142046.008b04d0@pop.hipernet.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
Hi
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
test=>
test=>
test=>
test=> CREATE SEQUENCE seq_conex\g
CREATE
test=>
CREATE TABLE conex (
id int4 PRIMARY KEY DEFAULT NEXTVAL('seq_conex'),
hora time DEFAULT TEXT 'now',
ms int4 ,
dt datetime DEFAULT
TEXT 'now'
)\g
test-> test-> test-> test-> test-> NOTICE: CREATE
TABLE/PRIMARY KEY will create implicit index conex_pkey for table
conex
CREATE
test=> insert into conex (ms) values (100000) \g
INSERT
6113923 1
test=> select * from conex\g
id|hora | ms|dt
--+--------+------+--------------------------
1|13:58:39|100000|12/02/1999 13:58:39.00 EDT
(1 row)
--
-- After +- 2 minutes ...
--
test=> insert into conex (ms) values (140110) \g
INSERT 6113924 1
test=>
select * from conex\g
id|hora | ms|dt
--+--------+------+--------------------------
1|13:58:39|100000|12/02/1999 13:58:39.00 EDT
2|13:58:39|140110|12/02/1999
13:58:39.00 EDT ==> I think should be 14:01:10.00
(2 rows)
test=>
Thank You!
Roberto
------------------------------------------------------------------
Eng. Roberto João Lopes Garcia E-mail: roberto(at)mha(dot)com(dot)br
F. 55 11 848 9906 FAX 55 11 848 9955
MHA Engenharia Ltda
E-mail: mha(at)mha(dot)com(dot)br WWW: http://www.mha.com.br
Av Maria Coelho Aguiar, 215 Bloco D 2 Andar
Centro Empresarial de Sao Paulo
Sao Paulo - BRASIL - 05805 000
-------------------------------------------------------------------
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: | Raw Message | Whole Thread | Download mbox | Resend email |
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 * *
-----------------------------------------------------------------*****----------