"John Guthrie" <[EMAIL PROTECTED]> writes:
> select (seconds*100)+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.
> i have a schema that stores timestamps in seconds/microseconds format.
> each
> column in the table is int4. what i want to do is to compute the int8
> value
> of total microseconds, a la:
> select (seconds*100)+micros from my_table;
> but it looks to me like postgresql puts the rresult int
