Re: enums

Поиск
Список
Период
Сортировка
От Trent Shipley
Тема Re: enums
Дата
Msg-id 200510271723.03405.tshipley@deru.com
обсуждение исходный текст
Ответ на Re: enums  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: enums  (Michael Glaesemann <grzm@myrealbox.com>)
Re: enums  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
On Thursday 2005-10-27 16:22, Andrew Dunstan wrote:
> Jim C. Nasby wrote:
> >Like I said, if we're going to support a concept of ordering of items in
> >an enum then we need to support it fully. For starters that means having
> >the ability to re-order things in an enum seamlessly.
>
> I do not see this at all. An enumeration defines an ordering and a set
> of labels. Why should you be able to change it?  If you want a different
> ordering, create a new enumeration. Let's do this right because it's a
> feature worth having, not just mimic the competition's idiocy
>

The symbols in the set have no _per se_ order.
A collation rule is necessary to sort the symbols consistently.
ASCII is an enumeration
Unicode is a large enumeration with a simple naive collation and a complex 
default collation.

Defining a set results in an unordered specification of symbols.
Defining a collation produces an ordering for the set.
There can be many collations for a set.

An enumeration is just a computer science short-hand way to define a set and a 
"native" collation for the set. 
An enumeration's native collation need not be the only, or even the most 
common, collation for the enumerated set of symbols.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: enums
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: enums