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

From Tom Lane
Subject Re: ~Strange Operators~
Date
Msg-id 14988.1088645068@sss.pgh.pa.us
Whole thread Raw
In response to ~Strange Operators~  (Chris Gamache <cgg007@yahoo.com>)
Responses Re: ~Strange Operators~
List pgsql-general
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

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: Running PostgreSQL on Windows 9x/2000/2003...
Next
From: Tom Lane
Date:
Subject: Re: Internationalization