<br /><br /> On 10/24/2010 05:09 PM, Andrew Dunstan wrote: <blockquote cite="mid:4CC4A07E.2040104@dunslane.net"
type="cite"><br/><br /><blockquote>select enum_oid, row_number() over () as sort_order<br /> from unnest(null::myenum)
asenum_oid<br /><br /></blockquote><br /></blockquote><br /> Of course, I meant:<br /><br /><blockquote>select
enum_label,row_number() over () as sort_order<br /> from unnest(enum_range(null::myenum)) as enum_label<br /><br
/></blockquote>cheers<br /><br /> andrew<br /><blockquote></blockquote>