enumerated type..

From: "raptor(at)tvskat(dot)net" <raptor(at)tvskat(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: enumerated type..
Date: 2004-07-19 13:43:28
Message-ID: 20040719164328.07dedef4@bugs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-07-19 13:46:02 Re: Question on INSERT statement
Previous Message Anton Nikiforov 2004-07-19 12:33:52 Re: LOG table changes ...