PostgreSQL

PostgreSQL Elephant Logo

64.6. Limitations

GIN assumes that indexable operators are strict. This means that extractValue will not be called at all on a null item value (instead, a placeholder index entry is created automatically), and extractQuery will not be called on a null query value either (instead, the query is presumed to be unsatisfiable). Note however that null key values contained within a non-null composite item or query value are supported.


Prev Up Next

64.5. GIN Tips and Tricks

Home

64.7. Examples

Copyright © 1996-2023 The PostgreSQL Global Development Group