Re: extensible enum types
Andrew Dunstan <andrew@dunslane.net>
From: Andrew Dunstan <andrew@dunslane.net>
To: "David E. Wheeler" <david@kineticode.com>
Cc: Robert Haas <robertmhaas@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-06-18T16:59:10Z
Lists: pgsql-hackers
David E. Wheeler wrote: > On Jun 18, 2010, at 9:34 AM, Andrew Dunstan wrote: > > >> I'd be perfectly happy to hear a reasonable alternative. Assuming we use some integer representation, given two labels represented by n and n+1, we can't add a label between them without rewriting the tables that use the type, whether it's my representation scheme or some other. Maybe we could have a FORCE option which would rewrite if necessary. >> > > People would likely always use it. > > Why not use a decimal number? > > > You are just bumping up the storage cost. Part of the attraction of enums is their efficiency. cheers andrew