is this expected behavior? if so, then why? -tfo
db=# create table foo( col timestamp ); db=# select cast( extract( epoch from col ) as numeric( 15, 6 ) ) from foo; date_part ----------- (0 rows) db=# insert into foo values( current_timestamp ); INSERT 1705954 1 db=# select cast( extract( epoch from col ) as numeric( 15, 6 ) ) from foo; ERROR: overflow on numeric ABS(value) >= 10^9 for field with precision 15 scale 6 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
