Thread

'Default' troubles again. This time with time :)))

Leon <leon@udmnet.ru> — 1999-07-18T09:52:58Z

Hello!

Look at this:

bdb=> create table dd (aa int4, gg timestamp default 'now');
CREATE
bdb=> insert into  dd (aa) values (5);
INSERT 581771 1
bdb=> select * from dd;
aa|gg
--+----------------------
 5|1999-07-18 14:40:02+05    
(1 row)


So far so good. But some seconds later:


bdb=> insert into  dd (aa) values (6);
INSERT 581772 1
bdb=> select * from dd;
aa|gg
--+----------------------
 5|1999-07-18 14:40:02+05
 6|1999-07-18 14:40:02+05
(2 rows)


See? Time haven't changed! And again:


bdb=> insert into  dd (aa) values (123);
INSERT 581773 1
bdb=> select * from dd;
 aa|gg
---+----------------------
  5|1999-07-18 14:40:02+05
  6|1999-07-18 14:40:02+05
123|1999-07-18 14:40:02+05
(3 rows) 

Seems there is lot'a trouble with default values :)

-- 
Leon.