Re: int1?

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: int1?
Date: 2003-10-09 08:19:09
Message-ID: 20031009081909.GA35964@perrin.nxad.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Is there any date type that can be used for 0-255
> values? Like an "int1" or byte column.

A SMALLINT is two bytes on disk, use "char" instead. This is a hidden
goodie in PostgreSQL and one that I wish was exposed via a more
conventional syntax (*hint hint*).

http://developer.postgresql.org/docs/postgres/datatype-character.html#DATATYPE-CHARACTER-SPECIAL-TABLE

-sc

--
Sean Chittenden

In response to

  • int1? at 2003-10-09 07:16:05 from CSN

Responses

  • Re: int1? at 2003-10-09 14:39:17 from Ron Johnson
  • Re: int1? at 2003-10-09 14:52:06 from Karsten Hilbert
  • Re: int1? at 2003-10-09 14:59:55 from Stephan Szabo

Browse pgsql-general by date

  From Date Subject
Next Message Ang Chin Han 2003-10-09 08:44:03 Re: Does postgresql support HKSCS ?
Previous Message Ron Johnson 2003-10-09 07:36:55 Re: int1?