Re: Distinct types

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Simon Riggs <simon(at)2ndQuadrant(dot)com>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Distinct types
Date: 2008-11-28 16:09:21
Message-ID: 493017B1.7050604@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David E. Wheeler wrote:
>
> Speaking of other sorts of derived types: might they include something
> just like enums, but sorting on the string values defined for the enum
> rather than on the order in which the values were defined in the enum?
> I'd use something like that all the time…
>
>

order by foo_enum::text ...

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-11-28 16:10:27 Re: Comments to Synchronous replication patch v3
Previous Message David E. Wheeler 2008-11-28 15:58:43 Re: Distinct types