Susanne Ebrecht <susa...@2ndquadrant.com> writes: > On 07.03.2011 17:43, Tom Lane wrote: >> because two expressions that are equal() must necessarily have the same >> collation >> property.
> Peter, Tom, > I am not able to see this. > If 'abc' == 'abc' is not collation depending at all. It is only > encoding depending. Sorry, I was using a term of art there. This isn't about data values, it's about parsed expression trees. See the equal() function in src/backend/nodes/equalfuncs.c. If two expression trees match according to equal(), then they must necessarily have the same collation property, because equal() compares all the fields and in particular the collation fields. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers