On 2/3/14, 11:23 PM, plademan(at)comcast(dot)net wrote:
> It appears that default values are no longer working in 9.3.1.
>
> insert into default_test
> ( userId, date1, date2, date3 )
> values
> ( null, null, null, null );
>
> select * from default_test;
This wouldn't have worked in previous versions either. You want:
INSERT INTO default_test (userid, date1, date2, date) VALUES
(DEFAULT, DEFAULT, DEFAULT, DEFAULT)
or perhaps
INSERT INTO default_test DEFAULT VALUES;
Regards,
Marko Tiikkaja