problems with variabiles in plpgsql
Good day everybody,
My problem is that i can't use a variabile to name a table, like this:
select INTO id,domeniu idp,nume FROM $2 where idc=$1;
^^
I was having the same problem with creating a table:
create table $1(id serial,stuff text);
^^
was give me the same error:
010404.09:17:45.062 [767] ERROR: parser: parse error at or near "$1"
010404.09:17:45.063 [767] DEBUG: Last error occured while executing
PL/pgSQL function domenii
010404.09:17:45.063 [767] DEBUG: line 8 at select into variables
Is there any problem naming tables with variabiles????
I haven't find anything in the manual.
Thanks very much.
Diana Cionoiu
Import Notes
Reply to msg id not found: slrn9cm16k.bme.jdassen@odin.cistron-office.nl
To the best of my knowledge, you can't use parameters for table names. But
if you have 7.1, you can use the EXECUTE command to dynamically generate
(and execute) any SQL statement. Check out:
http://postgresql.readysetnet.com/devel-corner/docs/programmer/plpgsql-descr
iption.html
Specifically: 24.2.5.3. Executing dynamic queries
Greg
----- Original Message -----
From: "Diana Cionoiu" <diana@softwaresolutions.ro>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, April 04, 2001 2:27 AM
Subject: problems with variabiles in plpgsql
Show quoted text
Good day everybody,
My problem is that i can't use a variabile to name a table, like this:
select INTO id,domeniu idp,nume FROM $2 where idc=$1;
^^
I was having the same problem with creating a table:create table $1(id serial,stuff text);
^^
was give me the same error:010404.09:17:45.062 [767] ERROR: parser: parse error at or near "$1"
010404.09:17:45.063 [767] DEBUG: Last error occured while executing
PL/pgSQL function domenii
010404.09:17:45.063 [767] DEBUG: line 8 at select into variablesIs there any problem naming tables with variabiles????
I haven't find anything in the manual.
Thanks very much.
Diana Cionoiu
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)