Re: Resolve UNKNOWN type to relevant type instead of text type while bulk update using values

[Tom Lane]

Ashutosh Bapat <ashutosh.bapat....@gmail.com> writes:
> we cast a quoted value to UNKNOWN type, but this is a special value
> null which can be casted to any SQL data type. Probably we could add a
> ANYNULLTYPE or some such generic null type which can be casted to any
> data type. Then a null value without any type is labeled as
> ANYNULLTYPE if specific type information is not available.

And ... how does that differ from the existing behavior of UNKNOWN?

                        regards, tom lane