Received: from hipernet.com.br ([200.246.90.107]) by hub.org (8.9.2/8.9.1) with ESMTP id LAA96342 for ; Fri, 12 Feb 1999 11:25:46 -0500 (EST) (envelope-from roberto@mha.com.br) Received: from pc35.mha.com.br (dialsp5p2.hipernet.com.br [200.246.90.157]) by hipernet.com.br (8.8.8+Sun/8.8.8) with SMTP id OAA13569 for ; Fri, 12 Feb 1999 14:21:52 -0200 (EDT) Message-Id: <3.0.5.32.19990212142046.008b04d0@pop.hipernet.com.br> X-Sender: roberto@pop.hipernet.com.br X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.5 (32) Date: Fri, 12 Feb 1999 14:20:46 -0200 To: pgsql-sql@postgreSQL.org From: Roberto Joao Lopes Garcia Subject: DEFAULT TEXT 'now' in create table Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id LAA96375 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 -------------------------------------------------------------------