Re: ~Strange Operators~

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: cgg007(at)yahoo(dot)com, Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: ~Strange Operators~
Date: 2004-07-01 03:14:36
Message-ID: 40E3819C.4040007@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

> Chris Gamache <cgg007(at)yahoo(dot)com> writes:
>
>>~>=~
>>~<=~
>>~<>~
>>~<~
>>~=~
>>~>~
>
>
>>They aren't familiar to me, but I can tell that they are text comparison
>>operators. The details of what and how they compare is a mystery to me!
>
>
> Those are the non-locale-aware operators that Peter added to support
> LIKE. I'm surprised to hear they aren't documented.
>
> regards, tom lane
>
What are they, just binary?

BTW, isn't that what locale C is, binary?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2004-07-01 03:30:11 Re: Internationalization
Previous Message Bill Moran 2004-07-01 03:08:13 Re: Dump / restore for optimization?