Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id CAA28975 for postgres-dist; Fri, 1 Apr 1994 02:09:01 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199404011009.CAA28975@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from ieug54.ie.cuhk.hk (ieug54.ie.cuhk.hk [137.189.96.44]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id CAA28966 for ; Fri, 1 Apr 1994 02:08:56 -0800 From: wklaw1@ie.cuhk.hk Received: by ieug54.ie.cuhk.hk (5.57/Ultrix3.0-C) id AA06268; Fri, 1 Apr 94 18:11:34 +0800 Date: Fri, 1 Apr 94 18:11:34 +0800 Message-Id: <9404011011.AA06268@ieug54.ie.cuhk.hk> To: postgres@postgres.Berkeley.EDU Subject: signed or unsiged type ??!! Cc: shlam@ie, tmlam@ie Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Fri, 01 Apr 94 02:09:00 -0800 Resent-XMts: smtp Hi all Postgres Ver 4.1 users, I am wondering whether the type, int2, is signed or unsigned.. The User Manual tells me that int2 is SIGNED integer, but I found that it should be UNSIGNED integer since if I assigned a negative number to an attribute (which defined as int2), an error will be reported by Postgres.... I doubt is there any mistake I made or I misunderstand while creating the tables. Any advice is appreciated, THANK YOU Regards, Keith LAw