Re: problems with variabiles in plpgsql

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


> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>