problems with variabiles in plpgsql - Mailing list pgsql-general

From Diana Cionoiu
Subject problems with variabiles in plpgsql
Date
Msg-id Pine.LNX.4.30.0104040921560.768-100000@tudor.softwaresolutions.ro
Whole thread Raw
In response to Re: unrecognized language plpgsql  (jdassen@cistron.nl (J.H.M. Dassen (Ray)))
List pgsql-general
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


pgsql-general by date:

Previous
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: unrecognized language plpgsql
Next
From: DaVinci
Date:
Subject: Inheritance and views