Re: Debet-Credit-Balance Calculation

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(dot)nasedkin(dot)perm(at)mail(dot)ru