Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with question marks in operators (JDBC, ECPG, ...) - Mailing list pgsql-hackers

From Mike Blackwell
Subject Re: Problems with question marks in operators (JDBC, ECPG, ...)
Date
Msg-id CANPAkguKzWRn-WNDqLJ3dR0YE6TQdXxOaq9ujRBna1DTCMsUZw@mail.gmail.com
Whole thread Raw
In response to Re: Problems with question marks in operators (JDBC, ECPG, ...)  (Bruno Harbulot <bruno@distributedmatter.net>)
Responses Re: Problems with question marks in operators (JDBC, ECPG, ...)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
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.Blackwell@rrd.com
http://www.rrdonnelley.com



On Tue, May 19, 2015 at 12:45 PM, Bruno Harbulot <bruno@distributedmatter.net> wrote:


On Tue, May 19, 2015 at 6:15 PM, Mike Blackwell <mike.blackwell@rrd.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.

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: a few thoughts on the schedule
Next
From: Tom Lane
Date:
Subject: Re: Problems with question marks in operators (JDBC, ECPG, ...)