Hi,
I want to create a function in plpgsql that must execute a INSERT
query on the database. The problem comes in I want to create the query
inside the function. Look at the following:
CREATE OR REPLACE FUNCTION Test_Function(integer) RETURNS VOID
AS $$
DECLARE
table_name text := 'My_Table_Name';
BEGIN
INSERT INTO "table_name" VALUES ($1);
END
$$ LANGUAGE plpgsql;
When I try to create the function I get the following response from Postgres:
ERROR: syntax error at or near "$1"
LINE 1: INSERT INTO $1 VALUES ( $2 )
^
QUERY: INSERT INTO $1 VALUES ( $2 )
CONTEXT: SQL statement in PL/PgSQL function "test_function" near line 4
What am I missing? Is it possible to do what I want to do? And if so
how should I do it.
Note: The function is only to show what the problem is, actual
function should look a lot different.
Any help will be appreciated
Thank you
--
Carel Combrink
s25291930@tuks.co.za
This message and attachments are subject to a disclaimer. Please refer
to www.it.up.ac.za/documentation/governance/disclaimer/ for full
details. / Hierdie boodskap en aanhangsels is aan 'n vrywaringsklousule
onderhewig. Volledige besonderhede is by
www.it.up.ac.za/documentation/governance/disclaimer/ beskikbaar.
