enumerated type.. - Mailing list pgsql-general

From raptor@tvskat.net
Subject enumerated type..
Date
Msg-id 20040719164328.07dedef4@bugs
Whole thread Raw
Responses Re: enumerated type..
Re: enumerated type..
List pgsql-general
hi,

Is it possible in Postgre to have enum type,  so that later table fileld get values from 1-6 (saving space)

1 - statex
2 - stateY
3 - stateZ

something like that and then constrain on this enum type..

tia

pgsql-general by date:

Previous
From: Anton Nikiforov
Date:
Subject: Re: LOG table changes ...
Next
From: Tom Lane
Date:
Subject: Re: Question on INSERT statement