On Fri, Mar 09, 2007 at 04:55:59AM -0800, psmith wrote:
When change a column type from timestamp to date, the 'infinity' and '-
infinity' values will be NULL. Even if the column has a not null
constraint.
[...]
version
Michael Fuhr [EMAIL PROTECTED] writes:
On Fri, Mar 09, 2007 at 04:55:59AM -0800, psmith wrote:
When change a column type from timestamp to date, the 'infinity' and '-
infinity' values will be NULL. Even if the column has a not null
constraint.
This appears to be fixed already:
Hi!
When change a column type from timestamp to date, the 'infinity' and '-
infinity' values will be NULL. Even if the column has a not null
constraint.
Sorry, if it is a duplicated bug report.
Regards,
psmith
Here is the test procedure:
proba2=# create table a(t timestamp not null);
CREATE