Re: ~Strange Operators~

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

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-07-01 01:28:46 Re: Internationalization
Previous Message Justin Clift 2004-07-01 01:21:02 Re: Running PostgreSQL on Windows 9x/2000/2003...