[SQL] EXECUTE with a prepared plan and NULL

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

Re: [SQL] EXECUTE with a prepared plan and NULL

sergey kapustin kapustin.ser...@gmail.com 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.