Re: Conflict of implicit collations doesn't propagate out of subqueries

2020-05-28 Thread Markus Winand
> On 28.05.2020, at 23:43, Tom Lane wrote: > > Markus Winand writes: >> However, if the conflict happens in a subquery, it doesn’t anymore: > >>WITH data (c, posix) AS ( >>values ('a' COLLATE "C", 'b' COLLATE "POSIX") >>) >>SELECT * >> FROM (S

Re: Conflict of implicit collations doesn't propagate out of subqueries

2020-05-28 Thread Tom Lane
Markus Winand writes: > However, if the conflict happens in a subquery, it doesn’t anymore: > WITH data (c, posix) AS ( > values ('a' COLLATE "C", 'b' COLLATE "POSIX") > ) > SELECT * > FROM (SELECT *, c || posix AS none FROM data) data >