Before PostgreSQL 12, WITH was always materialized, but since PostgreSQL 12 this is not necessarily the case (it's up to the query planner).
However, a new syntax was added for explicitly specifying whether a WITH query should be MATERIALIZED or NOT MATERIALIZED. This commit adds support for this to Opaleye's core, and adds the function withMaterialized to the user-facing API.
tomjaguarpaw
commented
11 months ago
Before PostgreSQL 12,
WITHwas always materialized, but since PostgreSQL 12 this is not necessarily the case (it's up to the query planner).However, a new syntax was added for explicitly specifying whether a
WITHquery should beMATERIALIZEDorNOT MATERIALIZED. This commit adds support for this to Opaleye's core, and adds the functionwithMaterializedto the user-facing API.