Horton

Re: s/LABEL/VALUE/ for ENUMs

David Wheeler <david@kineticode.com>

View thread
From: "David E. Wheeler" <david@kineticode.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andrew Dunstan <andrew@dunslane.net>, PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>
Date: 2010-11-23T00:48:17Z
Lists: pgsql-hackers 
On Nov 22, 2010, at 4:46 PM, Tom Lane wrote:

>> Oh my boots and buttons. I think we're splitting some very fine hairs 
>> here. A few weeks back you were telling us that label wasn't a very good 
>> word and shouldn't be sanctified in the SQL.
> 
> It isn't a very good word for the abstract value, IMO, but the text
> representation is a different concept.

But that's the thing we've been talking about all along! It's now

  ALTER ENUM ADD VALUE 'FOO';

But that sets the text value, the label, not the abstract value.

Boots and buttons indeed.

David