X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CB91153322 for ; Tue, 19 Apr 2005 23:32:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77360-06 for ; Wed, 20 Apr 2005 02:32:18 +0000 (GMT) Received: from mail.ccl.ru (mail.ccl.ru [195.222.130.78]) by svr1.postgresql.org (Postfix) with ESMTP id 1DA365355E for ; Tue, 19 Apr 2005 23:32:17 -0300 (ADT) Received: from s02.mz.intra (mail.mz.perm.ru [195.222.129.14]) by mail.ccl.ru (8.13.1/8.13.1) with ESMTP id j3K2VlgN087407; Wed, 20 Apr 2005 08:31:50 +0600 (YEKST) Received: from server1c ([192.168.22.73]) by s02.mz.intra with Microsoft SMTPSVC(6.0.3790.211); Wed, 20 Apr 2005 08:31:47 +0600 Date: Wed, 20 Apr 2005 08:28:58 +0600 From: Mihail Nasedkin X-Mailer: The Bat! (v2.00) CD5BF9353B3B7091 Reply-To: Mihail Nasedkin X-Priority: 3 (Normal) Message-ID: <1412347250.20050420082858@mail.ru> To: "Muhyiddin A.M Hayat" Cc: pgsql-sql@postgresql.org Subject: Re: Debet-Credit-Balance Calculation In-Reply-To: <001c01c544ff$bb94d650$1f00a8c0@middinks> References: <001c01c544ff$bb94d650$1f00a8c0@middinks> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-OriginalArrivalTime: 20 Apr 2005 02:31:47.0118 (UTC) FILETIME=[196D2CE0:01C54551] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.255 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200504/297 X-Sequence-Number: 21190 I think you forget FOREIGN KEY: transactions.trx_type_id -> trx_type.id MAMH> Dear All, MAMH> I have problem to calculation MAMH> balance from debet and credit. MAMH> my transaction table: ... MAMH> CREATE TABLE "public"."transactions" ( MAMH>   MAMH> "id" SERIAL, MAMH>   "trx_timestamptz" TIMESTAMP(0) WITH TIME ZONE DEFAULT MAMH> ('now'::text)::timestamp(6) with time zone NOT NULL, MAMH>   "account" MAMH> CHAR(16) NOT NULL, MAMH>   "trx_type_id" INTEGER NOT NULL, MAMH>   MAMH> "amount" NUMERIC(15,2) DEFAULT 0 NOT NULL, MAMH>   "uid" INTEGER NOT NULL, MAMH>   CONSTRAINT "transactions_pkey" PRIMARY KEY("id") MAMH> ) WITH MAMH> OIDS; ... MAMH> and transaction type : ... MAMH> CREATE TABLE "public"."trx_type" ( MAMH>   "id" SERIAL, MAMH>   "trx_name" VARCHAR(32), MAMH>   "t_type" CHAR(2), MAMH>   MAMH> CONSTRAINT "trx_type_pkey" PRIMARY KEY("id"), MAMH>   CONSTRAINT MAMH> "trx_typei_check0" CHECK ((t_type = 'CR'::bpchar) OR (t_type = MAMH> 'DB'::bpchar)) MAMH> ) WITH OIDS;   MAMH> --------------------------------------------------------------------- MAMH> so, i'm using this query: ... MAMH> ... query eat all my cpu process and take a long time ... -- regards, Mihail mailto:m.nasedkin.perm@mail.ru