>>>>> "PG" == PG Bug reporting form <noreply(at)postgresql(dot)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)