Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group