Re: [HACKERS] analyzeCTE is too strict about typmods?

2017-09-21 Thread Kyotaro HORIGUCHI
At Thu, 03 Aug 2017 19:29:40 -0400, Tom Lane wrote in <28993.1501802...@sss.pgh.pa.us> > I wrote: > > In short, therefore, it's looking to me like analyzeCTE() is wrong here. > > It should allow the case where the recursive result has typmod -1 while > > the non-recursive output column has some m

Re: [HACKERS] analyzeCTE is too strict about typmods?

2017-08-03 Thread Tom Lane
I wrote: > In short, therefore, it's looking to me like analyzeCTE() is wrong here. > It should allow the case where the recursive result has typmod -1 while > the non-recursive output column has some more-specific typmod, so long > as they match on type OID. That would correspond to what we do in