At 15:12 23/11/01, you wrote:
>Last I checked, you cannot perform arithmetic functions inside a query. I
>suggest retrieving the values, do the math, then update.
You can perform all sorts of arithmetic operations inside a query in
Postgres, although sometimes you ave to be a bit clever with the syntax.
(I'm not sure how much of it is strict SQL92 though.) It would be a
nightmare working with datetimes if you couldn't subtract them from each
other, add intervals, etc.
Digital Mind Games -- log on to take over
In response to
pgsql-novice by date
|Next:||From: Peter Eisentraut||Date: 2001-11-23 21:57:54|
|Subject: Re: upper and lower doesn't work with german umlaut?|
|Previous:||From: Frank Bax||Date: 2001-11-23 17:22:52|
|Subject: Re: Update from a table.|