Re: Function `set_config` doesn't work in with query?

[Andrew Gierth <andrew@xxxxxxxxxxxxxxxxxxxx>]

>>>>> "Zexuan" == Zexuan Luo <spacewanderlzx@xxxxxxxxx> writes:

 Zexuan> For instance:
 Zexuan> ```
 Zexuan> with t as (
 Zexuan>     select set_config('blah', '1', false)
 Zexuan> )
 Zexuan>     select current_setting('blah');

A CTE containing a SELECT query which is not referenced anywhere will
not be executed, even if it contains volatile functions. (CTEs
containing INSERT/UPDATE/DELETE that are not referenced _will_ still be
executed.)

-- 
Andrew (irc:RhodiumToad)