pgsql: Teach convert_subquery_pathkeys() to handle the case where the

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Teach convert_subquery_pathkeys() to handle the case where the
Date: 2006-08-17 17:02:50
Message-ID: 20060817170250.0BBE79FA430@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
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.

Modified Files:
--------------
pgsql/src/backend/optimizer/path:
pathkeys.c (r1.77 -> r1.78)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/pathkeys.c.diff?r1=1.77&r2=1.78)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2006-08-17 17:06:37 pgsql: Fix an oversight in mergejoin planning: the planner would reject
Previous Message User Gsmet 2006-08-17 16:33:17 pgfouine - www: updated RPM