You could do a stored procedure for inserting into another table... Otherwise if
you want to get the result as a query, you could do something like,
Select field1, exp(field2) as expoffield2 from tablename1
Hope that helps,
Srini
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org]
On Behalf Of vbhatia@ksu.edu
Sent: Sunday, July 29, 2007 10:08 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] mathematical calculations - sql queries
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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match