<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/postgresql.git/contrib/pg_trgm/pg_trgm.sql.in, branch master</title>
<subtitle>git.postgresql.org: git/postgresql.git
</subtitle>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/'/>
<entry>
<title>Convert contrib modules to use the extension facility.</title>
<updated>2011-02-14T03:54:49+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2011-02-14T01:06:41+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=629b3af27d5c2bc9d6e16b22b943ad651d4ecb56'/>
<id>629b3af27d5c2bc9d6e16b22b943ad651d4ecb56</id>
<content type='text'>
This isn't fully tested as yet, in particular I'm not sure that the
"foo--unpackaged--1.0.sql" scripts are OK.  But it's time to get some
buildfarm cycles on it.

sepgsql is not converted to an extension, mainly because it seems to
require a very nonstandard installation process.

Dimitri Fontaine and Tom Lane
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
This isn't fully tested as yet, in particular I'm not sure that the
"foo--unpackaged--1.0.sql" scripts are OK.  But it's time to get some
buildfarm cycles on it.

sepgsql is not converted to an extension, mainly because it seems to
require a very nonstandard installation process.

Dimitri Fontaine and Tom Lane
</pre>
</div>
</content>
</entry>
<entry>
<title>Support LIKE and ILIKE index searches via contrib/pg_trgm indexes.</title>
<updated>2011-02-01T02:34:49+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2011-02-01T02:33:55+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=6e2f3ae8842392c46ccc91a9ce4bba92296890cb'/>
<id>6e2f3ae8842392c46ccc91a9ce4bba92296890cb</id>
<content type='text'>
Unlike Btree-based LIKE optimization, this works for non-left-anchored
search patterns.  The effectiveness of the search depends on how many
trigrams can be extracted from the pattern.  (The worst case, with no
trigrams, degrades to a full-table scan, so this isn't a panacea.  But
it can be very useful.)

Alexander Korotkov, reviewed by Jan Urbanski
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Unlike Btree-based LIKE optimization, this works for non-left-anchored
search patterns.  The effectiveness of the search depends on how many
trigrams can be extracted from the pattern.  (The worst case, with no
trigrams, degrades to a full-table scan, so this isn't a panacea.  But
it can be very useful.)

Alexander Korotkov, reviewed by Jan Urbanski
</pre>
</div>
</content>
</entry>
<entry>
<title>Add KNNGIST support to contrib/pg_trgm.</title>
<updated>2010-12-04T05:16:21+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2010-12-04T05:16:21+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=b525bf771e31a2254f28bf25c6ed7987d64c8afb'/>
<id>b525bf771e31a2254f28bf25c6ed7987d64c8afb</id>
<content type='text'>
Teodor Sigaev, with some revision by Tom
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Teodor Sigaev, with some revision by Tom
</pre>
</div>
</content>
</entry>
<entry>
<title>Remove useless whitespace at end of lines</title>
<updated>2010-11-23T20:34:55+00:00</updated>
<author>
<name>Peter Eisentraut</name>
<email>peter_e@gmx.net</email>
</author>
<published>2010-11-23T20:27:50+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=fc946c39aeacdff7df60c83fca6582985e8546c8'/>
<id>fc946c39aeacdff7df60c83fca6582985e8546c8</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Remove cvs keywords from all files.</title>
<updated>2010-09-20T20:08:53+00:00</updated>
<author>
<name>Magnus Hagander</name>
<email>magnus@hagander.net</email>
</author>
<published>2010-09-20T20:08:53+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=9f2e211386931f7aee48ffbc2fcaef1632d8329f'/>
<id>9f2e211386931f7aee48ffbc2fcaef1632d8329f</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Mark contrib's GiST and GIN opclass support functions as STRICT, for safety.</title>
<updated>2009-06-11T18:30:03+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2009-06-11T18:30:03+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=d94582f4f8a06e08c8b054d332174165de6e40a6'/>
<id>d94582f4f8a06e08c8b054d332174165de6e40a6</id>
<content type='text'>
(Note: GiST penalty functions could possibly be non-strict, but none are at
present.)
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
(Note: GiST penalty functions could possibly be non-strict, but none are at
present.)
</pre>
</div>
</content>
</entry>
<entry>
<title>Adjust the APIs for GIN opclass support functions to allow the extractQuery()</title>
<updated>2009-03-25T22:19:02+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2009-03-25T22:19:02+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=87b8db37740bb044cb3b6a6439e656217869fd57'/>
<id>87b8db37740bb044cb3b6a6439e656217869fd57</id>
<content type='text'>
method to pass extra data to the consistent() and comparePartial() methods.
This is the core infrastructure needed to support the soon-to-appear
contrib/btree_gin module.  The APIs are still upward compatible with the
definitions used in 8.3 and before, although *not* with the previous 8.4devel
function definitions.

catversion bump for changes in pg_proc entries (although these are just
cosmetic, since GIN doesn't actually look at the function signature before
calling it...)

Teodor Sigaev and Oleg Bartunov
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
method to pass extra data to the consistent() and comparePartial() methods.
This is the core infrastructure needed to support the soon-to-appear
contrib/btree_gin module.  The APIs are still upward compatible with the
definitions used in 8.3 and before, although *not* with the previous 8.4devel
function definitions.

catversion bump for changes in pg_proc entries (although these are just
cosmetic, since GIN doesn't actually look at the function signature before
calling it...)

Teodor Sigaev and Oleg Bartunov
</pre>
</div>
</content>
</entry>
<entry>
<title>Push index operator lossiness determination down to GIST/GIN opclass</title>
<updated>2008-04-14T17:05:34+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2008-04-14T17:05:34+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=9b5c8d45f62bd3d243a40cc84deb93893f2f5122'/>
<id>9b5c8d45f62bd3d243a40cc84deb93893f2f5122</id>
<content type='text'>
"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.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
"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.
</pre>
</div>
</content>
</entry>
<entry>
<title>Fix completely-bogus volatility markings on pg_trgm functions.</title>
<updated>2007-12-09T02:22:46+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2007-12-09T02:22:46+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=cb1ab30fdc3b44a7d34ccf9cdaa82d46dd6427c1'/>
<id>cb1ab30fdc3b44a7d34ccf9cdaa82d46dd6427c1</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Add CVS version labels to all install/uninstall scripts.</title>
<updated>2007-11-13T04:24:29+00:00</updated>
<author>
<name>Bruce Momjian</name>
<email>bruce@momjian.us</email>
</author>
<published>2007-11-13T04:24:29+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=33e2e024938578598625ad14034432378db88af1'/>
<id>33e2e024938578598625ad14034432378db88af1</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
