Yesterday, Hubert ‘depesz’ Lubaczewski wrote a post about new functionality in PostgreSQL 9.1.
In a few words we will have the ability to add new values to the existing ENUM type defined earlier. Thanks God!
However, Andrew Dunstan proposed to use another syntax for it:
ALTER TYPE enumtype ADD LABEL ‘newlabel’
The discussion was hot. Brendan Jurd wanted previous syntax, Tom Lane proposed substitution VALUE for LABEL, Pavel Stehule made a suggestion for ELEMENT etc.
What term sounds good for you, friend?
This topic is discussed again and again with huge friend of mine and MySQL sectarian. And must confess I agree with him in this particular point of view.
For me it’s strange that such powerful database as PostgreSQL, which has a lot of drums and whistles inside, doesn’t support SET types. Especially when we have ENUM support now!
Of course one may say that this functionality can be implemented using Bit String Types. But where is the joy of power? Where is the crystal clarity of the SQL script?
What’s you opinion, postgresman?
PS Don’t hesitate to share your thoughts in the comments.
PS Decided to check wordpress.com Poll functionality.