Re: Problems with question marks in operators (JDBC, ECPG, ...)

From: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
To: Bruno Harbulot <bruno(at)distributedmatter(dot)net>
Cc: Kevin Grittner <kgrittn(at)ymail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Greg Sabino Mullane <greg(at)turnstep(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Problems with question marks in operators (JDBC, ECPG, ...)
Date: 2015-05-19 18:14:44
Message-ID: CANPAkguKzWRn-WNDqLJ3dR0YE6TQdXxOaq9ujRBna1DTCMsUZw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

See for example
http://docs.oracle.com/cd/B19306_01/text.102/b14218/cqoper.htm#i997330,
Table 3-1, third row, showing the precedence of '?'. Further down the
page, under "Fuzzy" see "Backward Compatibility Syntax".

__________________________________________________________________________________
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike(dot)Blackwell(at)rrd(dot)com
http://www.rrdonnelley.com

<http://www.rrdonnelley.com/>
* <Mike(dot)Blackwell(at)rrd(dot)com>*

On Tue, May 19, 2015 at 12:45 PM, Bruno Harbulot <
bruno(at)distributedmatter(dot)net> wrote:

>
>
> On Tue, May 19, 2015 at 6:15 PM, Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
> wrote:
>
>> A Google search suggests Oracle 9.x supports a unary '?' operator (fuzzy
>> match), so the use of '?' in an operator name is not without precedent.
>>
>>
> Interesting. Do you have any specific link? I'm probably not using the
> right Google search, but the nearest reference I've found is for Oracle 10,
> and it seems to use the tilde (~) operator for fuzzy matching:
> http://www.oracle.com/technetwork/search/oses/overview/new-query-features-in-10-1-8-2-1-132287.pdf
>
> Best wishes,
>
> Bruno.
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2015-05-19 18:22:43 Re: Problems with question marks in operators (JDBC, ECPG, ...)
Previous Message Peter Geoghegan 2015-05-19 18:02:15 Re: a few thoughts on the schedule