Re: int1?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: int1?
Date: 2003-10-09 20:36:05
Message-ID: 3F85C6B5.7000604@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron Johnson wrote:
> On Thu, 2003-10-09 at 02:16, CSN wrote:
>
>>Is there any date type that can be used for 0-255
>>values? Like an "int1" or byte column.
>
> An int2 with a constraint on it.
>

You can use the data type "char" (with the quotes, and without a (n)
decoration). See:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=datatype-character.html
near the bottom of the page.

Joe

In response to

  • Re: int1? at 2003-10-09 07:36:55 from Ron Johnson

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Welche 2003-10-09 20:49:52 Re: autoupdate sequences after copy
Previous Message Ron Johnson 2003-10-09 20:24:09 Re: Domains (was Re: int1?)