EXECUTE with a prepared plan and NULL
От | sergey kapustin |
---|---|
Тема | EXECUTE with a prepared plan and NULL |
Дата | |
Msg-id | cf82f1380901041253j52268ee6od8962c712cf8ca0f@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: EXECUTE with a prepared plan and NULL
|
Список | pgsql-sql |
<div dir="ltr">Hello!<br /><br />I'm trying to run this code in one of my stored procedures <br /><br />s := 'execute prepared_plan(' || id_engine || ',' || id_search || ',' || id_rsite || ')';<br /> execute s;<br /><br /><br />where "prepared_plan"is a statement defined before with PREPARE. <br /><br />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 - <br /><br />ERROR: cannot EXECUTE a null querystring<br />CONTEXT: PL/pgSQL function "factorize" line 148 at execute statement<br/><br />how this can be solved? (I want to send NULL to the prepared statement when one of the parameters isnull)<br /><br />Another small question -<br />Why when i remove the "execute" from the beginning of s and run it likethis - <br /><br />s := 'prepared_plan( ' || id_engine || ',' || id_search || ',' || id_rsite || ')';<br /> execute s;<br/><br />then i get a syntax error? <br /><br /><br /><br />Thank you!<br /></div>
В списке pgsql-sql по дате отправления: