Re: BUG #15286: BEFORE or AFTER not working while adding values for existing enums - Mailing list pgsql-bugs

>>>>> "PG" == PG Bug reporting form <noreply@postgresql.org> writes:

 PG> I'm trying to modify an existing enum and use the BEFORE or AFTER
 PG> feature to add a value in between the existing values but I'm
 PG> noticing that the values are only being added to the enum in the
 PG> end.

How are you looking at the order of values?

I get this:

create type e1 as enum ('foo','bar','baz');
alter type e1 add value 'quux' after 'foo';

postgres=# select * from unnest(enum_range(null::e1)) order by 1;
 unnest 
--------
 foo
 quux
 bar
 baz
(4 rows)

which is the expected order.

-- 
Andrew (irc:RhodiumToad)