]> granicus.if.org Git - postgresql/commit
Teach convert_subquery_pathkeys() to handle the case where the
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 17 Aug 2006 17:02:49 +0000 (17:02 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 17 Aug 2006 17:02:49 +0000 (17:02 +0000)
commit144b0ae8ee36aa5dc7e036cee05004672b3c492e
tree5daf13d2cb6bb7258378f14920b84d06fbdee392
parent4e1bdcaabfc7da7835c9fcc909c7e9e7bf0575e0
Teach convert_subquery_pathkeys() to handle the case where the
subquery's pathkey is a RelabelType applied to something that appears
in the subquery's output; for example where the subquery returns a
varchar Var and the sort order is shown as that Var coerced to text.
This comes up because varchar doesn't have its own sort operator.
Per example from Peter Hardman.
src/backend/optimizer/path/pathkeys.c