Re: ~Strange Operators~ - Mailing list pgsql-general

From Dennis Gearon
Subject Re: ~Strange Operators~
Date
Msg-id 40E3819C.4040007@fireserve.net
Whole thread Raw
In response to Re: ~Strange Operators~  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:

> Chris Gamache <cgg007@yahoo.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?

pgsql-general by date:

Previous
From: Christopher Cashell
Date:
Subject: Re: Problems restarting after database crashed (signal 11).
Next
From: Bruno Wolff III
Date:
Subject: Re: backups