Postgres Pro
Downloads
Home   >   mailing lists

Re: int1? - Mailing list pgsql-general

From Sean Chittenden
Subject Re: int1?
Date
Msg-id 20031009081909.GA35964@perrin.nxad.com
Whole thread Raw
In response to int1?  (CSN <cool_screen_name90001@yahoo.com>)
Responses Re: int1?  (Ron Johnson <ron.l.johnson@cox.net>)
Re: int1?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Re: int1?  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: int1?
Next
From: Ang Chin Han
Date:
Subject: Re: Does postgresql support HKSCS ?