Skip site navigation (1) Skip section navigation (2)

Re: [JDBC] mathematical calculations - sql queries

From: "Srinivas Kotapally" <ksrinivas(at)coriendo(dot)com>
To: <vbhatia(at)ksu(dot)edu>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: [JDBC] mathematical calculations - sql queries
Date: 2007-07-30 10:54:43
Message-ID: 022001c7d298$0a054d10$3221a8c0@srinilaptop (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-jdbc
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(at)postgresql(dot)org [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]
On Behalf Of vbhatia(at)ksu(dot)edu
Sent: Sunday, July 29, 2007 10:08 PM
To: pgsql-jdbc(at)postgresql(dot)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


In response to

pgsql-admin by date

Next:From: Kees SmitDate: 2007-07-30 11:28:20
Subject: silent install under Windows giving problems
Previous:From: Srinivas KotapallyDate: 2007-07-30 10:20:14
Subject: Question about fixes and updates

pgsql-jdbc by date

Next:From: Dave CramerDate: 2007-07-31 15:55:20
Subject: statement caching patch from Laszlo Hornyak for review
Previous:From: Andres OlarteDate: 2007-07-30 02:38:46
Subject: Re: mathematical calculations - sql queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group