On Fri, Aug 9, 2024 at 2:14 PM yudhi s <learnerdatabase99@xxxxxxxxx> 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.
