Tom Lane wrote:
But probably making them act like identifiers is not a good idea, because I doubt we want automatic downcasing in enum_in. People wouldn't be happy if they had to write WHERE color = '"Red"' or
> something like that to get at a mixed-case enum label.
Ah, that's what you had in mind. Yeah, that's a bit verbose. > Let's
just throw the error instead. (I agree that enum_in can just fail with "no such label", but CREATE TYPE ought to give a specific error about it.)
Agreed. Andrew, you said you had a mostly-working patch already? Cheers Tom ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend