> 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?
Try (seconds::int8 * 10000000)+micros - you could use cast(...) if you want to be more standard. - Richard Huxton ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
