Re: add label to enum syntax

David Wheeler <david@kineticode.com>

From: "David E. Wheeler" <david@kineticode.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Alvaro Herrera <alvherre@commandprompt.com>, Dean Rasheed <dean.a.rasheed@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-10-27T16:19:51Z
Lists: pgsql-hackers
On Oct 27, 2010, at 7:18 AM, Andrew Dunstan wrote:

> The reason I chose LABEL was that it's consistent with what we have used elsewhere, both in the docs and the catalog. But I'm not strongly wedded to it. If it's a choice between ELEMENT and VALUE, I too prefer VALUE at it seems likelier to convey the sense of what we're doing to a naive user.

FWIW, MySQL seems to call them values:

> An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time.


-- http://dev.mysql.com/doc/refman/5.0/en/enum.html

Best,

David