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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Keith Worthington wrote:
> Hi All,
> I found this in the documentation. 
>     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


> 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                        |
  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-2018 The PostgreSQL Global Development Group