SET EXECUTE_SELECT_EXPRESSION_IN_MEMORY#
Controls where a SELECT with no FROM clause is evaluated. When ON (the default), such
source-less expressions — for example SELECT 1 + 1 — are evaluated by Querona’s in-memory
engine. When OFF, they are sent to the current database to be evaluated there instead.
Syntax#
SET EXECUTE_SELECT_EXPRESSION_IN_MEMORY { ON | OFF } [;]
Remarks#
A query with no FROM clause does not depend on any source table, so Querona can answer it with
its own in-memory engine without involving a connected database. Turning the option OFF routes
these expressions to the current database, which is useful when the expression relies on a function or
behaviour specific to that source. The default is ON.
Permissions#
Requires membership in the public role.
Examples#
SET EXECUTE_SELECT_EXPRESSION_IN_MEMORY OFF;
SELECT 1 + 1;