"John Guthrie" <[EMAIL PROTECTED]> writes: > select (seconds*1000000)+micros from my_table; > but it looks to me like postgresql puts the rresult into another int4 (since > i am getting negative numbers, i assume overflow). how can i get it to use > int8?
Cast the constant to int8.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
