Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id CBB809FA31D for ; Sun, 29 Jul 2007 23:07:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 34872-04 for ; Sun, 29 Jul 2007 23:07:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp2.cc.ksu.edu (smtp2.cc.ksu.edu [129.130.7.16]) by postgresql.org (Postfix) with ESMTP id B0F129FA34C for ; Sun, 29 Jul 2007 23:07:42 -0300 (ADT) Received: from imp2.cc.ksu.edu (imp2.cc.ksu.edu [129.130.12.181]) by smtp2.cc.ksu.edu (8.13.8/8.13.8) with ESMTP id l6U27eBK015711 for ; Sun, 29 Jul 2007 21:07:40 -0500 (CDT) Received: (from apache@localhost) by imp2.cc.ksu.edu (8.12.11.20060308/8.12.11/Submit) id l6U27eGl023929 for pgsql-jdbc@postgresql.org; Sun, 29 Jul 2007 21:07:40 -0500 X-Authentication-Warning: imp2.cc.ksu.edu: apache set sender to vbhatia@ksu.edu using -f Received: from ip70-179-167-45.fv.ks.cox.net (ip70-179-167-45.fv.ks.cox.net [70.179.167.45]) by webmail.ksu.edu (IMP) with HTTP for ; Sun, 29 Jul 2007 21:07:40 -0500 Message-ID: <1185761260.46ad47ec4a9b7@webmail.ksu.edu> Date: Sun, 29 Jul 2007 21:07:40 -0500 From: vbhatia@ksu.edu To: pgsql-jdbc@postgresql.org Subject: mathematical calculations - sql queries MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.3 X-Virus-Scanned: ClamAV 0.90.1/3813/Sun Jul 29 19:49:25 2007 on virusfilter3.cc.ksu.edu X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200707/136 X-Sequence-Number: 17310 Hi all, Thanks for replying to previous mail, I have one more question. Can I write a postgresql query that retrieves a particular field from a table and performs some mathematical calculation on that field involving exponential( exp) and pow functions and storing the result in a new table. Somethign like this select field1 from tablename1 ( performing calculation on field1 ) ( storing in another table) Thanks and regards, Vishal