Skip site navigation (1) Skip section navigation (2)

Re: Poor-man's enumeration type

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: KeithW(at)NarrowPathInc(dot)com
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Poor-man's enumeration type
Date: 2005-04-26 02:57:57
Message-ID: 200504260257.j3Q2vvo22189@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Keith Worthington wrote:
> Hi All,
> 
> I found this in the documentation. 
> http://www.postgresql.org/docs/8.0/interactive/datatype-character.html
> 
>     The type "char" (note the quotes) is different
>     from char(1)in that it only uses one byte of
>     storage. It is internally used in the system
>     catalogs as a poor-man's enumeration type.
> 
> Is this a SQL standard data type?  Can I expect this type
> to be supported in PostgreSQL 'forever'?  I need an enum

Yes.

> type and obviously this works.  At the moment I am not
> faced with an imminent port but I hate to back myself into
> a corner if I do not have to.


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-novice by date

Next:From: Michael GlaesemannDate: 2005-04-26 03:08:53
Subject: Re: Poor-man's enumeration type
Previous:From: Keith WorthingtonDate: 2005-04-26 02:52:39
Subject: Poor-man's enumeration type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group