Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruno Harbulot
Subject Re: Problems with question marks in operators (JDBC, ECPG, ...)
Date
Msg-id CANPVNBafsFEvncy5J=eRSHsM+9-M5GbJOqrgM=aTmbs4xqUe5w@mail.gmail.com
Whole thread Raw
In response to Re: Problems with question marks in operators (JDBC, ECPG, ...)  (Mike Blackwell <mike.blackwell@rrd.com>)
Responses Re: Problems with question marks in operators (JDBC, ECPG, ...)  (Mike Blackwell <mike.blackwell@rrd.com>)
List pgsql-hackers
Tree view


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: Andres Freund
Date:
Subject: Re: a few thoughts on the schedule
Next
From: Andres Freund
Date:
Subject: Re: Per row status during INSERT .. ON CONFLICT UPDATE?