Re: problem with variable

"coviolo(at)libero(dot)it" <coviolo(at)libero(dot)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