On Fri, Aug 9, 2024 at 2:14 PM yudhi s <learnerdatabase99(at)gmail(dot)com> wrote:
>
> Why so?
>
Because you stuck a CTE in between the column list of the insert - where
types are known - and the values command - where types are unknown since
you didn't specify them. As the row comes out of the CTE every column must
have a known type, and so in the absence of context they get typed as text.
David J.