conversi ms-sql7 vs postgresql 7.3

From: "betty" <liongliong(at)telkom(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: conversi ms-sql7 vs postgresql 7.3
Date: 2003-02-06 10:10:23
Message-ID: b1tbo9$2d0t$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi..

I have table xx:
id debet credit balance
1 1000 0 0
2 2000 0 0
3 0 2500 0
4 0 100 0

command in ms-sql 7 can use calculate field (column) balance from id=1 to
id=4:
"update xx set bal=balance=bal+debet-credit"
result:
id debet credit balance
1 1000 0 1000
2 2000 0 3000
3 0 2500 500
4 0 100 400

How command sql can use in psotgresql 7.3?

thank's a lot
betty.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ludwig Lim 2003-02-06 11:04:35 TIME vs. TIMESTAMP data type
Previous Message Christoph Haller 2003-02-06 09:51:21 Re: Lock timeout detection in postgres 7.3.1