From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How can I get a column INT4 to be UNSIGNED ? |
Date: | 2003-04-14 03:30:00 |
Message-ID: | 1050291000.24769.461.camel@haggis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 2003-04-11 at 16:09, Dennis Gearon wrote:
> If he wants the full range of an INT4 unsigned, he needs to go to INT8 with the
> constraint you mentioned. The underlying col type of INT4 only supports HALF of
> the range of an INT4 unsigned, in the positive domain, that is.
When domains allow CHECK constraints, that would be simplified, wouldn't
it?
--
+----------------------------------------------------------------+
| Ron Johnson, Jr. mailto:ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson |
| |
| "A C program is like a fast dance on a newly waxed dance floor |
| by people carrying razors." |
| Waldi Ravens |
+----------------------------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | milimeter@163.com | 2003-04-14 05:16:32 | Problem about pgsql's column alias |
Previous Message | Tom Lane | 2003-04-14 03:15:21 | Re: Index/Seq Scan Problem |