How can I get a column INT4 to be UNSIGNED ?

From: "Bruno Baguette" <bruno(dot)baguette(at)netcourrier(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How can I get a column INT4 to be UNSIGNED ?
Date: 2003-04-11 07:30:02
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAA/fD/VFTblUCgwdO0e3rg1gEAAAAA@netcourrier.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I would like to get a column of INT4, but instead having a range of
allowed values from -2147483648 to 2147483647, i would to get an
UNSIGNED range from 0 to 4294967295...

So, is it possible to create a column with an UNSIGNED INT4 type ? If
the answer is yes : what is the right syntax because I don't find the
right syntax to do that... :-/

Thanks a lot in advance for your help ! :-)

------------------------------------------------
Bruno BAGUETTE - bruno(dot)baguette(at)netcourrier(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message u_andy 2003-04-11 08:02:18 user authentication
Previous Message johnhui828 2003-04-11 06:45:23 Questions regarding PostgreSQL