Horton

Re: s/LABEL/VALUE/ for ENUMs

David Wheeler <david@kineticode.com>

View thread
From: "David E. Wheeler" <david@kineticode.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Andrew Dunstan <andrew@dunslane.net>, PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>
Date: 2010-11-23T19:01:33Z
Lists: pgsql-hackers 
On Nov 22, 2010, at 6:03 PM, Josh Berkus wrote:

> ... "original patch".  Sorry.  Let's not fiddle with the names.

To be clear, as things stand now, the new command is:

    ALTER TYPE name ADD VALUE new_enum_value [ { BEFORE | AFTER } existing_enum_value ]

So while the term in the SQL statement is "VALUE," it's called a "label" in the documentation. I think that's confusing. Does anyone else?

Best

David