Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group