update table field value II

From: "Muhammad Rusydi" <rusydi(at)cbn(dot)net(dot)id>
To: "Postgres General" <pgsql-general(at)postgreSQL(dot)org>
Subject: update table field value II
Date: 2001-01-14 23:47:46
Message-ID: 00a201c07e84$6753c560$6402a8c0@didi1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
i'm sorry there's some mistake on my last subject....it's should be...
i want to update some of my field for all records on table...
----------------------------
id sem period
----------------------------
A991 3 2000/2001
B992 1 2000/2001

and i want it will be updated automatically to be.....
----------------------------
id sem period
----------------------------
A991 4 2000/2001
B992 2 2000/2001

if date on the system or server (Postgres) changed from February 2000 to
March 2000....and it'll also be update...
----------------------------
id sem period
----------------------------
A991 5 2001/2002
B992 3 2001/2002

if the month change from September 2000 to February 2001....
is it possible to do this with Postgres?
If there's someone ever had experienced like this, i will be appreciate the
help (Oliver too)
piece...
Rusydi

Browse pgsql-general by date

  From Date Subject
Next Message Tod McQuillin 2001-01-15 00:15:59 Re: where to host??
Previous Message Brett W. McCoy 2001-01-14 21:58:46 Can't compare decimal columns???