Re: UNION versus collations

2024-11-18 Thread Laurenz Albe
On Mon, 2024-11-18 at 17:56 -0500, Tom Lane wrote: > prepunion.c's plan_union_children(), which merges > identically-propertied UNION operations into one, has this comment: > > * NOTE: currently, we ignore collations while determining if a child has > * the same properties. This is semantically

UNION versus collations

2024-11-18 Thread Tom Lane
prepunion.c's plan_union_children(), which merges identically-propertied UNION operations into one, has this comment: * NOTE: currently, we ignore collations while determining if a child has * the same properties. This is semantically sound only so long as all * collations have the same notion