Re: enums

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: tshipley(at)deru(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: enums
Date: 2005-10-28 01:05:40
Message-ID: 43617964.2070403@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Trent Shipley wrote:

>
>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.
>
>
>
>

No it's not. Many languages define enumerated types as having a fixed
ordering. It is not just a set. That is the sense in which I am using
the term. And, after all, you can always write a function that gives you
an alternative ordering. All we are building in is an ordering based in
the enumeration order, which you are at perfect liberty not to use.
Postgres lets you define an alternative operator class for any type, so
we are very flexible. People are getting way too hung up over this.

cheers

andrew

In response to

  • Re: enums at 2005-10-28 00:23:02 from Trent Shipley

Responses

  • Re: enums at 2005-10-28 01:35:41 from Cristian Prieto

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-10-28 01:12:15 relfilenode
Previous Message Grzegorz Jaskiewicz 2005-10-28 00:55:58 SOLVED Re: _penalty gist method invoked with one key NULL