pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Roberto Joao Lopes Garcia <roberto@mha.com.br>
To: pgsql-sql@postgreSQL.org
Subject: DEFAULT TEXT 'now' in create table
Date: Fri, 12 Feb 1999 14:20:46 -0200
Message-ID: <3.0.5.32.19990212142046.008b04d0@pop.hipernet.com.br> (raw)

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@mha.com.br
F. 55 11 848 9906   FAX  55 11 848 9955

MHA Engenharia Ltda
E-mail: mha@mha.com.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
-------------------------------------------------------------------




view thread (2+ messages)  latest in thread

Message-ID: <3.0.5.32.19990212142046.008b04d0@pop.hipernet.com.br>
Permalink:  ../3.0.5.32.19990212142046.008b04d0@pop.hipernet.com.br/
Also on:    postgresql.org/message-id/3.0.5.32.19990212142046.008b04d0@pop.hipernet.com.br

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: roberto@mha.com.br
  Subject: Re: DEFAULT TEXT 'now' in create table
  In-Reply-To: <3.0.5.32.19990212142046.008b04d0@pop.hipernet.com.br>
  References: <3.0.5.32.19990212142046.008b04d0@pop.hipernet.com.br>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox