X-Original-To: pgsql-sql@postgresql.org Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 414FF475F09 for ; Mon, 17 Mar 2003 15:51:59 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.8/8.12.8) with ESMTP id h2HKptub008288; Mon, 17 Mar 2003 15:51:56 -0500 (EST) To: "John Guthrie" Cc: pgsql-sql@postgresql.org Subject: Re: upcasting multiplication in a query In-reply-to: <037901c2ecc2$cea38a30$3dc810ac@corphq.psynapsetech.net> References: <037901c2ecc2$cea38a30$3dc810ac@corphq.psynapsetech.net> Comments: In-reply-to "John Guthrie" message dated "Mon, 17 Mar 2003 15:21:29 -0500" Date: Mon, 17 Mar 2003 15:51:55 -0500 Message-ID: <8287.1047934315@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200303/420 X-Sequence-Number: 12459 "John Guthrie" 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