Re: Cache lookup error when using jsonb, json_build_object and a WITH clause

Andres Freund <andres@2ndquadrant.com> writes:
> Whoa. There's two wierd things here:
> a) "jsonb" has a typcategory 'C'. Marking a composite type. "json" has
>    'U'.

Yeah, that's flat out wrong.  I changed it before seeing your message.

> b) datum_to_json() thinks it's a good idea to use typcategory to decide
>    how a type is output. Isn't that pertty fundamentally flawed?

Indeed.  I think the bit that uses TYPCATEGORY_NUMERIC as a hint to decide
whether the value can be left unquoted (assuming it looks like a number)
might be all right, but the rest of this seems pretty bogus.
        regards, tom lane