Re: Update from a table.

Last I checked, you cannot perform arithmetic functions inside a query.  I
suggest retrieving the values, do the math, then update.

Mark
----- Original Message -----
From: "Andrew Bell" <acbell@iastate.edu>
To: <pgsql-novice@postgresql.org>
Sent: 21 November, 2001 6:02 AM
Subject: [NOVICE] Update from a table.


> Hi,
>
> I want to update one table from another table based on a criteria.  For
> instance:
>
>             table1                           table2
> employee | salary | netSalary         employee | deductions
>
> I want to update table1.netSalary to be table1.salary - table2.deductions
where
>    table1.employee = table2.employee.
>
> I don't see any way to do something like this with the syntax.  What am I
> missing, or what can be recommended?
>
>
> -- Andrew Bell
> acbell@iastate.edu
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>