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