Automatic updation of value in one field on change in value of another field in Postgresql 9

Question

0.00/5 (No votes)

See more:

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

select areaName,due_date from updation where due_date=date_lastupdate+periodicity

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

Thanks in advance

Hi patel
thanx for replying
it was my typing error
i did the same as u told
but only the column names with no records were returned.

Posted 16-Sep-11 10:36am

shanboy

Updated 21-Sep-11 5:02am

v2

Add a Solution

2 solutions

Solution 1

Try this

SQL

select areaName,due_date from updation where due_date=date_lastupdate+periodicity

Why do you use due_date=due_date+periodicity?

Posted 18-Sep-11 18:41pm

Prerak Patel

Comments

shanboy 21-Sep-11 11:04am

Hi patel
thanx for replying
it was my typing error
i did the same as u told
but only the column names with no records were returned.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

André Kraak · Accepted Answer · 2011-09-21T05:11:00

Solution 2

If you are trying change the due_date field you should be using an update[^] statement.

Posted 21-Sep-11 5:11am

André Kraak

Updated 21-Sep-11 5:12am

v2

Comments

shanboy 22-Sep-11 10:48am

Hi Andre
thanx
It works
i thought by combining select and the formula in the statement i could get the result
thanx a lot...

shanboy 22-Sep-11 10:49am

Further i'm trying to use a trigger to update as soon as somre updation takes place