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

Re: Update from a table.

From: Mo Holkar <pgsql(at)digitalmindgames(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Update from a table.
Date: 2001-11-23 17:36:37
Message-ID: 5.1.0.14.2.20011123173229.04a5ab30@pop.ntlworld.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

best,

Mo



Mo Holkar
Digital Mind Games -- log on to take over
mo(dot)holkar(at)digitalmindgames(dot)com
http://www.digitalmindgames.com


In response to

pgsql-novice by date

Next:From: Peter EisentrautDate: 2001-11-23 21:57:54
Subject: Re: upper and lower doesn't work with german umlaut?
Previous:From: Frank BaxDate: 2001-11-23 17:22:52
Subject: Re: Update from a table.

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