"John Guthrie" <jguthrie(at)psynapsetech(dot)net> 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