Text comparison suddenly can't find collation? - Mailing list pgsql-hackers

From Johann 'Myrkraverk' Oskarsson
Subject Text comparison suddenly can't find collation?
Date
Msg-id x6ty402luz.fsf@2ndquadrant.com
Whole thread Raw
Responses Re: Text comparison suddenly can't find collation?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi all,

Why would a string comparison work in one case and not another?  In
the following example, it works to compare a and b, but not a and d.

This is in a C module which calls
 DirectFunctionCall2( text_le, d1, d2 );

DEBUG:  Comparing a == b
DEBUG:  Comparing a == d
ERROR: could not determine which collation to use for string
comparison

I'll try and see if I can come up with a minimal example in a bit.


--   Johann Oskarsson                http://www.2ndquadrant.com/    |[]  PostgreSQL Development, 24x7 Support, Training
andServices  --+--                                                                 |  Blog:
http://my.opera.com/myrkraverk/blog/


pgsql-hackers by date:

Previous
From: Hitoshi Harada
Date:
Subject: Re: reprise: pretty print viewdefs
Next
From: Fujii Masao
Date:
Subject: Re: Standalone synchronous master