I have to correct myself :(
"When an enum type is created, its members are assigned sort-order
positions 1..n. But members added later might be given negative or
fractional values of enumsortorder. The only requirement on these values is
that they be correctly ordered and unique within each enum type."
"ALTER TYPE name ADD VALUE new_enum_value [ { BEFORE | AFTER }
existing_enum_value ]"
So, one can add values to the type that have a higher oid, but a lower
enumorder.
The workaround will only work as long one does not alters the type by
adding values
in the sort order "BEFORE" :(
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.