mathematical calculations - sql queries

[vbhatia(at)ksu(dot)edu]

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