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