remove deprecated @@@ operator ? - Mailing list pgsql-hackers

From Oleg Bartunov
Subject remove deprecated @@@ operator ?
Date
Msg-id CAF4Au4wmUsZRVhR+ySpvabRfB_1D1fnrPY9TRAKO2DEbi4Cpgg@mail.gmail.com
Whole thread Raw
Responses Re: remove deprecated @@@ operator ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hello,

The  commit 9b5c8d45f62bd3d243a40cc84deb93893f2f5122 is now 10+ years
old, may be we could remove deprecated @@@ operator ?


Author: Tom Lane <tgl@sss.pgh.pa.us>
Date:   Mon Apr 14 17:05:34 2008 +0000

    Push index operator lossiness determination down to GIST/GIN opclass
    "consistent" functions, and remove pg_amop.opreqcheck, as per recent
    discussion.  The main immediate benefit of this is that we no longer need
    8.3's ugly hack of requiring @@@ rather than @@ to test weight-using tsquery
    searches on GIN indexes.  In future it should be possible to optimize some
    other queries better than is done now, by detecting at runtime whether the
    index match is exact or not.

    Tom Lane, after an idea of Heikki's, and with some help from Teodor.

Best Regards,
Oleg
-- 
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


pgsql-hackers by date:

Previous
From: Paul A Jungwirth
Date:
Subject: Re: SQL:2011 PERIODS vs Postgres Ranges?
Next
From: Tom Lane
Date:
Subject: Re: remove deprecated @@@ operator ?