Thread: Parameters are not prepared in some cases (PostgreSQL)
|
Replies:
1
-
Last Post:
Jul 9, 2017 1:17 PM
Last Post By: Dmitry Arefiev
|
|
|
Posts:
21
Registered:
2/22/15
|
|
Hi!
If use a query, for example,
do
$$
DECLARE v_BegDat TimeStamp;
begin
v_BegDat := :BegDat;
perform v_BegDat as result;
end;
$$;
then the parameter (BegDat) is determined and i can configure it. But when the query is executed, a "[FireDAC][Phys][libpq] ОШИБКА: ошибка синтаксиса (примерное положение ":")." error occurs. Most likely the parameter value is not substituted into the final query.
|
|
|
Posts:
1,406
Registered:
12/7/03
|
|
PostgreSQL does not support parameters inside of anonymous block. You should create function instead.
--
With best regards,
Dmitry
|
|
|
|
Legend
|
|
Helpful Answer
(5 pts)
|
|
Correct Answer
(10 pts)
|
|
Connect with Us