On Tue, Nov 21, 2017 at 12:05 PM, Tom Lane <[email protected]> wrote: > Ashutosh Bapat <[email protected]> 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
