Re: Newbie: Solution?

From: will trillich <will(at)serensoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Newbie: Solution?
Date: 2001-08-22 22:37:27
Message-ID: 20010822173727.D15403@serensoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 13, 2001 at 07:52:54PM +0800, Walter wrote:
> Hello Experts,
>
> A sum (manually entered or just a calculation field) must sprats into
> several small amounts. the sum entered to a database firstly; an error
> message is required to appear while you key in the last small amount, in
> case the total figure of the several small amounts is not equal to the
> sum entered before. You can't expect how many individual small amounts
> will be input to a same/different database. For instance, you have a
> monthly budget to spend but yet not know how many particular expenses
> will occur in the later days, and you always pay out exactly all the
> money.

hmm -- what was the question? :)

you want separate tables for each period? or is this just a
standard accounting situation?

see "table constraints" in the docs...

--
Khan said that revenge is a dish best served cold. I think
sometimes it's best served hot, chunky, and foaming.
- P.J.Lee ('79-'80)

will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oberpriller, Wade D. 2001-08-22 23:21:29 FW: Re: Dynamically discovering field names in PLPGSQL queries
Previous Message Peter Eisentraut 2001-08-22 22:32:43 Re: current_timestamp wrong