Horton

Re: WIP: extensible enums

Andrew Dunstan <andrew@dunslane.net>

View thread
From: Andrew Dunstan <andrew@dunslane.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dean Rasheed <dean.a.rasheed@gmail.com>, Greg Stark <gsstark@mit.edu>, Robert Haas <robertmhaas@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2010-10-24T21:24:07Z
Lists: pgsql-hackers 

On 10/24/2010 05:09 PM, Andrew Dunstan wrote:
>
>
>     select enum_oid, row_number() over () as sort_order
>     from unnest(null::myenum) as enum_oid
>
>

Of course, I meant:

    select enum_label, row_number() over () as sort_order
    from unnest(enum_range(null::myenum)) as enum_label

cheers

andrew