X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id EEAF447590C
	for <pgsql-sql@postgresql.org>; Fri,  7 Feb 2003 03:17:04 -0500 (EST)
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id 21BAB474E5C
	for <pgsql-sql@postgresql.org>; Fri,  7 Feb 2003 03:17:04 -0500 (EST)
Received: by news.hub.org (Postfix, from userid 8)
	id 047CF43A67A; Fri,  7 Feb 2003 03:17:03 -0500 (EST)
From: "betty" <liongliong@telkom.net>
X-Newsgroups: comp.databases.postgresql.sql
Subject: update column with rowtype
Date: Fri, 7 Feb 2003 15:26:36 +0700
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 46
Message-ID: <b1vq1o$krd$1@news.hub.org>
X-Complaints-To: usenet@news.hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/160
X-Sequence-Number: 11558

Hi..

I try "rowtype" in trigger, ex:
create or replace function fn_tr_aiu_pdcblc() returns trigger as '
declare
   c_pdcblc cursor for select * from t_pdcblc where fc_branch=new.fc_branch
and fc_bankacct=new.fc_bankacct;
   balance decimal(30,5);
   row_pdcblc t_pdcblc%rowtype;
begin
    balance:=0;
    if (select count(*) from t_pdcblc where fc_branch=new.fc_branch and
fc_bankacct=new.fc_bankacct and fd_trxdate<new.fd_trxdate)>0 then
        balance:=new.fm_balance from t_pdcblc where fc_branch=new.fc_branch
and fc_bankacct=new.fc_bankacct and fd_trxdate<new.fd_trxdate;
    end if;
    open c_pdcblc;
    for c_pdc in 1..(select count(*) from t_pdcblc where
fc_branch=new.fc_branch and fc_bankacct=new.fc_bankacct and
fd_trxdate>=new.fd_trxdate) loop
        fetch c_pdcblc into row_pdcblc;
        row_pdcblc.fm_balance :=
balance+row_pdcblc.fm_masuk-row_pdcblc.fm_keluar;
        raise  notice ''balance %'',row_pdcblc.fm_balance;
        new.fm_balance := row_pdcblc.fm_balance;
    end loop;
    close c_pdcblc;
    return new;
end;' language 'plpgsql';

the result of this trigger is;
  oid      |     fd_trxdate                |  fm_masuk    | fm_keluar |
fm_balance
--------+---------------------    +------------ +-----------+------------
 562784 | 2003-02-06 00:00:00 | 1000.00000 |   0.00000 |    0.00000

and which command  i could used to fill column fm_balance with 1000?
please gimme some idea...???

thank's
betty


thank's