On 03/11/2016 03:19 PM, Elein wrote:
An unused (yet) enum type cannot display the enum ranges. An empty table
containing that type cannot display enum ranges.
The example selects were what I did to figure out that enum_ranges only
worked on existing data. Sorry if they were confusing. But the way enum
values are currently displayed is confusing.
Enums are evil because of the difficulty working with them. They should
be used for a fixed set of valid values. Otherwise use a lookup table.
"Otherwise use a lookup table."
That is the solution to this problem.
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
