pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedsigned/unsigned integers
4+ messages / 3 participants
[nested] [flat]
* signed/unsigned integers
@ 2002-08-23 09:11 Roger Mathis <traderx@gmx.ch>
0 siblings, 1 reply; 4+ messages in thread
From: Roger Mathis @ 2002-08-23 09:11 UTC (permalink / raw)
To: pgsql-sql
Hi
Is it true, that I can't define unsigned integers in a table definition?
CU Roger
^ permalink raw reply [nested|flat] 4+ messages in thread
* signed/unsigned integers
@ 2002-08-28 08:09 Roger Mathis <traderx@gmx.ch>
0 siblings, 1 reply; 4+ messages in thread
From: Roger Mathis @ 2002-08-28 08:09 UTC (permalink / raw)
To: pgsql-sql
Hi
Is it true, that I can't define unsigned integers in a table definition?
CU Roger
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: signed/unsigned integers
@ 2002-08-28 08:15 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: Roger Mathis <traderx@gmx.ch>
0 siblings, 0 replies; 4+ messages in thread
From: Christopher Kings-Lynne @ 2002-08-28 08:15 UTC (permalink / raw)
To: Roger Mathis <traderx@gmx.ch>; pgsql-sql
> Is it true, that I can't define unsigned integers in a table definition?
>
> CU Roger
I'm not aware of any unsigned types in Postgres. You could probably define
your own one though.
Chris
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: signed/unsigned integers
@ 2002-08-29 13:41 Bruno Wolff III <bruno@wolff.to>
parent: Roger Mathis <traderx@gmx.ch>
0 siblings, 0 replies; 4+ messages in thread
From: Bruno Wolff III @ 2002-08-29 13:41 UTC (permalink / raw)
To: Roger Mathis <traderx@gmx.ch>; +Cc: pgsql-sql
On Fri, Aug 23, 2002 at 11:11:51 +0200,
Roger Mathis <traderx@gmx.ch> wrote:
> Hi
>
> Is it true, that I can't define unsigned integers in a table definition?
If the main issue is that there not be negative numbers, you can use a
constraint to enforce this. In 7.3 you can define a domain with the
constraint and use it similar to a type.
If you need 32-63 bits worth of information, then you can use bigint with
some performance penalty. If you need 64 bits or more of information,
then you might be able to use numeric with an even larger performance hit.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2002-08-29 13:41 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-08-23 09:11 signed/unsigned integers Roger Mathis <traderx@gmx.ch>
2002-08-29 13:41 ` Bruno Wolff III <bruno@wolff.to>
2002-08-28 08:09 signed/unsigned integers Roger Mathis <traderx@gmx.ch>
2002-08-28 08:15 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
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