On Tue, Nov 21, 2017 at 12:05 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Ashutosh Bapat <ashutosh.ba...@enterprisedb.com> writes: >> While reviewing patch for similar problem in postgres_fdw [1], I >> noticed that we don't use positional notation while creating the view. >> This might introduced anomalies when GROUP BY entries are >> non-immutable. > > Yeah, we probably ought to make more of an effort to regenerate the > original query wording. I do not think that forcing positional notation > is a suitable answer in this case, because it would result in converting > SQL-standard queries to nonstandard ones.
Who cares? The other end is presumptively PostgresSQL, because this is postgres_fdw. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company