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*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?
thanks.
---
john guthrie
jguthrie@psynapsetech.net