On 12/29/18 12:07 AM, Mitar wrote:
Hi! Is it possible to use placeholders and provide values to the query when creating a materialized view? It looks like direct passing of values to the query is not possible and I have to encode them?
The only way I could see to do that is using dynamic SQL in a function: https://www.postgresql.org/docs/11/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN Or use something like pl/pythonu.
Mitar
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
