update table field value II

Поиск
Список
Период
Сортировка
От Muhammad Rusydi
Тема update table field value II
Дата
Msg-id 00a201c07e84$6753c560$6402a8c0@didi1
обсуждение исходный текст
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: "Brett W. McCoy"
Дата:
Сообщение: Can't compare decimal columns???
Следующее
От: admin
Дата:
Сообщение: odbc