EXECUTE with a prepared plan and NULL

Поиск
Список
Период
Сортировка
Искать
От
sergey kapustin
Тема
EXECUTE with a prepared plan and NULL
Дата
Msg-id
cf82f1380901041253j52268ee6od8962c712cf8ca0f@mail.gmail.com
Список
Дерево обсуждения
EXECUTE with a prepared plan and NULL "sergey kapustin" <kapustin.sergey@gmail.com>
Re: EXECUTE with a prepared plan and NULL Tom Lane <tgl@sss.pgh.pa.us>
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 string s becomes NULL also ( because NULL||"any string" = NULL) and as a result i get this error -

ERROR:  cannot EXECUTE a null querystring
CONTEXT:  PL/pgSQL function "factorize" line 148 at execute statement

how this can be solved? (I want to send NULL to the prepared statement when one of the parameters is null)

Another small question -
Why when i remove the "execute" from the beginning of s and run it like this -

s := 'prepared_plan( ' || id_engine || ',' || id_search || ',' || id_rsite || ')';
execute s;

then i get a syntax error?



Thank you!
В списке pgsql-sql по дате отправления
От: John Zhang
Дата:
От: Adrian Klaver
Дата:
FAQ