From: Muhyiddin A.M Hayat <middink@indo.net.id>
To: Steve Crawford <scrawford@pinpointresearch.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Calc
Date: Fri, 17 Oct 2003 09:38:05 +0800
Message-ID: <000001c3946c$86ff1a30$1f00a8c0@middinkcomp> (raw)
References: <002e01c39356$d5885ca0$1f00a8c0@middinkcomp>
<200310151331.22516.scrawford@pinpointresearch.com>
<001101c3940c$29f004e0$1f00a8c0@middinkcomp>
<200310161035.35762.scrawford@pinpointresearch.com>
> > trx_date | trx_time | descriptions |
> > payment_method | debet | credit | creator
> > ------------+----------+--------------------------------------+----
> >--------- ---+-------+----------+---------
> > 2003-10-09 | 21:55:02 | Resto Biling : 13,800, Paid : 10,000 |
> > Visa
> >
> > | 3800 | | middink
> >
> > 2003-10-16 | 03:28:30 | Payment - Thank You |
> > Visa
> >
> > | | 40000.00 | middink
> >
> > 2003-10-08 | 18:17:40 | Payment - Thank You |
> > Cash
> >
> > | | 50000.00
>
> The id field only keeps the transactions in the correct order so you
> can sum the previous transactions. You can do the same thing with
> your date and time fields (though using a single datetime field would
> be easier). A caution, though: you will have trouble if two
> transactions share the same date and time.
if i would like to pleaced ID(Virtual ID) for example number of record for
each record, how to ?
num_rec | trx_date | trx_time | credit |
descriptions | payment_method | debet
---------+------------+----------+----------+-------------------------------
-------------------------+----------------+-------
1 | 2003-10-09 | 21:55:02 | | Resto Biling : Rp.
13,800, Paid : Rp. 10,000 | Visa | 3800
2 | 2003-10-16 | 03:28:30 | 40000.00 | Payment
| Visa |
3 | 2003-10-08 | 18:17:40 | 50000.00 | Payment
| Cash |
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: middink@indo.net.id, scrawford@pinpointresearch.com
Subject: Re: Calc
In-Reply-To: <000001c3946c$86ff1a30$1f00a8c0@middinkcomp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox