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

On Thu, Jul 19, 2018 at 10:15 PM, Andrew Gierth

<andrew@tao11.riddles.org.uk> wrote:

>>>>> "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)