diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2025-07-03 16:24:31 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2025-07-03 16:24:31 -0400 |
| commit | e2b64fcef35f70f96fa92db56fbfa9ac2da136c7 (patch) | |
| tree | 35752a03406e9cf3b9edc1cdbe45fdbdf9e63f6d /doc/src | |
| parent | 0059bbe1ecaa5f7f19a8b3aae059f352c02e1d88 (diff) | |
| download | postgresql-e2b64fcef35f70f96fa92db56fbfa9ac2da136c7.tar.gz postgresql-e2b64fcef35f70f96fa92db56fbfa9ac2da136c7.zip | |
Add cross-type comparisons to contrib/btree_gin.
Extend the infrastructure in btree_gin.c to permit cross-type
operators, and add the code to support them for the int2, int4,
and int8 opclasses. (To keep this patch digestible, I left
the other datatypes for a separate patch.) This improves the
usability of btree_gin indexes by allowing them to support the
same set of queries that a regular btree index does.
Author: Tom Lane <tgl@sss.pgh.pa.us>
Reviewed-by: Arseniy Mukhin <arseniy.mukhin.dev@gmail.com>
Discussion: https://postgr.es/m/262624.1738460652@sss.pgh.pa.us
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/gin.sgml | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/doc/src/sgml/gin.sgml b/doc/src/sgml/gin.sgml index 46e87e01324..82410b1fbdf 100644 --- a/doc/src/sgml/gin.sgml +++ b/doc/src/sgml/gin.sgml @@ -394,7 +394,11 @@ Pointer extra_data)</function></term> <listitem> <para> - Compare a partial-match query key to an index key. Returns an integer + Compare a partial-match query key to an index key. + <literal>partial_key</literal> is a query key that was returned + by <function>extractQuery</function> with an indication that it + requires partial match, and <literal>key</literal> is an index entry. + Returns an integer whose sign indicates the result: less than zero means the index key does not match the query, but the index scan should continue; zero means that the index key does match the query; greater than zero |