diff options
author | Peter Eisentraut <peter@eisentraut.org> | 2020-11-19 09:24:37 +0100 |
---|---|---|
committer | Peter Eisentraut <peter@eisentraut.org> | 2020-11-19 09:32:47 +0100 |
commit | 01e658fa74cb7e3292448f6663b549135958003b (patch) | |
tree | d87a206912e085d7bcdadc424b571055055e58e2 /src/include/catalog/pg_amop.dat | |
parent | 7888b0999488511e4266f2134053fa3a6505a155 (diff) | |
download | postgresql-01e658fa74cb7e3292448f6663b549135958003b.tar.gz |
Hash support for row types
Add hash functions for the record type as well as a hash operator
family and operator class for the record type. This enables all the
hash functionality for the record type such as hash-based plans for
UNION/INTERSECT/EXCEPT DISTINCT, recursive queries using UNION
DISTINCT, hash joins, and hash partitioning.
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://www.postgresql.org/message-id/flat/38eccd35-4e2d-6767-1b3c-dada1eac3124%402ndquadrant.com
Diffstat (limited to 'src/include/catalog/pg_amop.dat')
-rw-r--r-- | src/include/catalog/pg_amop.dat | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/src/include/catalog/pg_amop.dat b/src/include/catalog/pg_amop.dat index bbe357fbc0..c7fee9f3ab 100644 --- a/src/include/catalog/pg_amop.dat +++ b/src/include/catalog/pg_amop.dat @@ -979,6 +979,11 @@ amoprighttype => 'oidvector', amopstrategy => '1', amopopr => '=(oidvector,oidvector)', amopmethod => 'hash' }, +# record_ops +{ amopfamily => 'hash/record_ops', amoplefttype => 'record', + amoprighttype => 'record', amopstrategy => '1', + amopopr => '=(record,record)', amopmethod => 'hash' }, + # text_ops { amopfamily => 'hash/text_ops', amoplefttype => 'text', amoprighttype => 'text', amopstrategy => '1', amopopr => '=(text,text)', |