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