Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f52F2UE34424 for ; Sat, 2 Jun 2001 11:02:30 -0400 (EDT) (envelope-from ler@lerctr.org) Received: (from ler@localhost) by lerami.lerctr.org (8.12.0.Beta7/8.12.0.Beta7/20010318/$Revision: 1.22 $) id f52F2PWC002896; Sat, 2 Jun 2001 10:02:25 -0500 (CDT) (envelope-from ler) Date: Sat, 2 Jun 2001 10:02:25 -0500 From: Larry Rosenman To: Tom Lane Cc: PostgreSQL SQL List Subject: Re: trying to summarize into a new table by time... Message-ID: <20010602100225.A2848@lerami.lerctr.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <11883.991493939@sss.pgh.pa.us> User-Agent: Mutt/1.3.18i X-Mailer: Mutt http://www.mutt.org/ X-Archive-Number: 200106/17 X-Sequence-Number: 3220 * Tom Lane [010602 09:59]: > > One more question, will the sum() on a bigint column cast to float > > happen in floating point? > > Yes. You don't really need that though. These days there are only > two flavors of sum(): float8 accumulator (for float8 and float4 inputs) > and numeric accumulator (for everything else). You don't need to worry > about overflow anymore. float8 is faster if you don't mind loss of > precision... Since I'm looking at order of magnitude type comparisons, the float8 is fine. I don't need to know down to the byte, just comparisons between orders of magnitudes. ISP's move a *LOT* of data :-) LER > > regards, tom lane -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749