Re: problem with variable
От | coviolo@libero.it |
---|---|
Тема | Re: problem with variable |
Дата | |
Msg-id | 33515231.2920681276093476921.JavaMail.defaultUser@defaultHost обсуждение исходный текст |
Ответ на | problem with variable ("coviolo@libero.it" <coviolo@libero.it>) |
Ответы |
Re: problem with variable
|
Список | pgsql-novice |
something like this: IF (TG_OP = 'UPDATE') THEN EXECUTE 'CREATE TABLE '||NEW.nome_tabella||' (ordinativo serial PRIMARY KEY CHECK (nome_tabella = '''||NEW.nome_tabella||'''::text)) INHERITS (database_t); 3 quotes first and 3 quotes after the second variable? tnx Luca >----Messaggio originale---- >Da: tim@tim-landscheidt.de >Data: 09/06/2010 14.02 >A: <pgsql-novice@postgresql.org> >Ogg: Re: [NOVICE] problem with variable > >"coviolo@libero.it" <coviolo@libero.it> wrote: > >> When the trigger executes the function which I copy below: > >> IF (TG_OP = 'UPDATE') THEN >> EXECUTE 'CREATE TABLE '||NEW.nome_tabella||' (ordinativo serial PRIMARY KEY >> CHECK (nome_tabella = '||NEW.nome_tabella||'::text)) > ^ ^ >> INHERITS (database_t); > >> first use of the variable '||NEW.nome_tabella||' is correct and the table is >> created with the name, for example "azienda_vallone", but I do not know why, >> the second use of the variable is incorrect because the CHECK insert on table >> is nome_tabella = azienda_vallone.*. >> I can not understand why postgresql insert point and asterisk at the end of >> the variable. >> if anyone can give me some suggestions on how to resolve... > >You probably need to replace the last two quotes with " ' ' ' ". > >Tim > > >-- >Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-novice >
В списке pgsql-novice по дате отправления: