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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers