Re: unsigned int4

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Scott(dot)Jackson(at)pnl(dot)gov
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: unsigned int4
Date: 2000-04-04 03:14:41
Message-ID: 200004040314.XAA11758@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I looked in the FAQs, lists, docs, etc but couldn't find an answer to my
> question.
> Is there a way to specify an unsigned int, such that it would create an
> ERROR condition if a transaction
> were to attempt to cause a particular value to go negative. This would
> be very useful to me.
> I would like to be able to use the automatic rollback feature of WORK
> blocks if a debit is generated that would
> subtract more than it's positive balance. I feel this would be helpful
> due to the concurrent nature of our bank
> application.

Oid should be unsigned int. Not sure it is completely implemented, but
it should be.

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gary Hoffman 2000-04-04 04:03:44 Fetching record of the day
Previous Message Robert W. Berger 2000-04-04 02:50:05 Re: SELECT speed with LIKE