problems with variabiles in plpgsql

Поиск
Список
Период
Сортировка
От Diana Cionoiu
Тема problems with variabiles in plpgsql
Дата
Msg-id Pine.LNX.4.30.0104040921560.768-100000@tudor.softwaresolutions.ro
обсуждение исходный текст
Ответ на Re: unrecognized language plpgsql  (jdassen@cistron.nl (J.H.M. Dassen (Ray)))
Список 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 по дате отправления:

Предыдущее
От: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Дата:
Сообщение: Re: unrecognized language plpgsql
Следующее
От: DaVinci
Дата:
Сообщение: Inheritance and views