By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Updation of value in one field depending on change in another field in postgresql 9

P: 20
hi all
i have fields date_lastupdate,peiodicity(data type is interval),due_date.
What i'm trying to do is
when the date_lastupdate changes ,periodicity(which may be different for each row),due_date field gets updated by following formula
due_date=date_lastupdate+periodicity

when i queried with
Expand|Select|Wrap|Line Numbers
  1. select areaName,due_date from updation where due_date=due_date+periodicity

I get only columns areaName,due_date with no records...
plz help me

Thanks in advance
Sep 16 '11 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 700
I do not get your problem. There are no rows in table that meet given where clause.
Sep 20 '11 #2

Rabbit
Expert Mod 10K+
P: 12,347
You need to run an update query, not a select query.
Sep 20 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.