sraoss / pg_ivm

IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
Other
854 stars 24 forks source link

Support types that does not have an equality operator #61

Open yugo-n opened 1 year ago

yugo-n commented 1 year ago

If an IMMV contains a column whose type does not have an equality operator, for example, json or xml, the following error is raised.

ERROR: could not identify an equality operator for type json

The current pg_ivm doesn't support such types. So, this should be documented and also checked in create_immv.

Moreover, I would like to allow to use such type in future.