Re: Weird "could not determine which collation to use for string comparison" with LEAST/GREATEST on PG11 procedure

Tom Lane <[email protected]> Tue, 05 Feb 2019 09:46:27 -0500

Newsgroups	gmane.comp.db.postgresql.sql,gmane.comp.db.postgresql.bugs
Message-ID	<[email protected]>

Peter Eisentraut <[email protected]> writes:
> On 21/11/2018 19:19, Tom Lane wrote:
>> Yeah, same here.  I think somebody forgot to run assign_expr_collations()
>> on CALL arguments.

> This appears to fix it.

I think this should be fine as a band-aid patch.  As I mentioned
previously, I'm not really happy with our generally-unprincipled
approach to where collation assignment is called from ... but a
bug-fix patch should probably not be tasked with making that
better.  Especially not with less than a week till 11.2.

			regards, tom lane