"sergey kapustin" writes:
> The thing is, that if i one of the parameters is NULL, then string s becomes
> NULL also ( because NULL||"any string" = NULL) and as a result i get this
> error -
> ERROR: cannot EXECUTE a null querystring
quote_nullable() might help.
regards,
Hello!
I'm trying to run this code in one of my stored procedures
s := 'execute prepared_plan( ' || id_engine || ',' || id_search || ',' ||
id_rsite || ')';
execute s;
where "prepared_plan" is a statement defined before with PREPARE.
The thing is, that if i one of the parameters is NULL, then