]> granicus.if.org Git - postgresql/commit
Fix UNION/INTERSECT/EXCEPT so that when two inputs being merged have
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 10 Aug 2006 02:36:29 +0000 (02:36 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 10 Aug 2006 02:36:29 +0000 (02:36 +0000)
commit0ee26100b64702f2fb4cd65c6dfdfb8f31e88130
treea10c4a1937f8707bc94950216ee8fdb4f0a61fe8
parente860e746e15a6c3bc26d7e337162a22e403f5a79
Fix UNION/INTERSECT/EXCEPT so that when two inputs being merged have
same data type and same typmod, we show that typmod as the output
typmod, rather than generic -1.  This responds to several complaints
over the past few years about UNIONs unexpectedly dropping length or
precision info.
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/nodes/outfuncs.c
src/backend/nodes/readfuncs.c
src/backend/optimizer/path/allpaths.c
src/backend/optimizer/prep/prepjointree.c
src/backend/optimizer/prep/prepunion.c
src/backend/optimizer/util/tlist.c
src/backend/parser/analyze.c
src/include/catalog/catversion.h
src/include/nodes/parsenodes.h