Re: [GENERAL] Unsigned Datatypes
> On Thu, Jan 20, 2000 at 05:18:36PM -0500, Bruce Momjian wrote: > > > The standard doesn't provide for specifically unsigned types, so I do not > > > believe anyone would want to go through that trouble. Sorry. > > > > Actually, oid data type is an unsigned int4. If it does not behave that > > way, it is a bug. > > is this just in pgsql, or in SQL in general? Just PostgreSQL. Others don't have oids. -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
Re: [GENERAL] Unsigned Datatypes
On Thu, Jan 20, 2000 at 05:18:36PM -0500, Bruce Momjian wrote: > > The standard doesn't provide for specifically unsigned types, so I do not > > believe anyone would want to go through that trouble. Sorry. > > Actually, oid data type is an unsigned int4. If it does not behave that > way, it is a bug. is this just in pgsql, or in SQL in general? -- [ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654 ] [ Reptilian Research -- Longer Life through Colder Blood ] [ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
Re: [GENERAL] Unsigned Datatypes
[Charset ISO-8859-1 unsupported, filtering to ASCII...] > The standard doesn't provide for specifically unsigned types, so I do not > believe anyone would want to go through that trouble. Sorry. Actually, oid data type is an unsigned int4. If it does not behave that way, it is a bug. -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
Re: [GENERAL] Unsigned Datatypes
The standard doesn't provide for specifically unsigned types, so I do not believe anyone would want to go through that trouble. Sorry. On 2000-01-19, Martin Neumann mentioned: > Are there any plans to implement unsigned datatypes like uint4 and > uint8? > > In many cases I don't need the signed int4 numbers, but I would be happy > to have a larger range without using the twice as large int8 type. > > -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden