Text comparison suddenly can't find collation?

From: "Johann 'Myrkraverk' Oskarsson" <johann(at)2ndquadrant(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Text comparison suddenly can't find collation?
Date: 2012-01-13 05:49:08
Message-ID: x6ty402luz.fsf@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2012-01-13 06:31:23 Re: Standalone synchronous master
Previous Message Hitoshi Harada 2012-01-13 05:31:13 Re: reprise: pretty print viewdefs