On Mon, Oct 10, 2005 at 11:52:40PM -0700, Dann Corbit wrote: > How about something like: > > CREATE DOMAIN unsigned_small AS smallint check (VALUE >= 0) > > CREATE DOMAIN unsigned_int AS integer check (VALUE >= 0) > > CREATE DOMAIN unsigned_big AS bigint check (VALUE >= 0) > > The objection might be that we lose one bit of field width. > But the extra safety is probably worth it if you really need unsigned > and want to avoid ambiguity.
Certainly. But I was more interested in the space. :P -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
