thoroughly broken examples on the Dynamic SQL page
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/ecpg-dynamic.html
Description:
Has anyone tried the examples on the
https://www.postgresql.org/docs/11/ecpg-dynamic.html Dynamic SQL page? The
very first line in each example immediately throws a syntax error: "syntax
error at or near "exec"". Could we get this updated or a bug fixed? I'm
migrating from SQL Server and really need to know how to migrate dynamic SQL
in existing code.
On Thu, 2020-02-27 at 15:52 +0000, PG Doc comments form wrote:
Has anyone tried the examples on the
https://www.postgresql.org/docs/11/ecpg-dynamic.html Dynamic SQL page? The
very first line in each example immediately throws a syntax error: "syntax
error at or near "exec"". Could we get this updated or a bug fixed? I'm
migrating from SQL Server and really need to know how to migrate dynamic SQL
in existing code.
You are confused.
This page is about embedded SQL in C.
If you want to write a stored procedure or function that uses dynamic SQL,
read https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com