Re: problem with variable - Mailing list pgsql-novice

From coviolo@libero.it
Subject Re: problem with variable
Date
Msg-id 18239246.2936121276097016430.JavaMail.defaultUser@defaultHost
Whole thread Raw
In response to problem with variable  ("coviolo@libero.it" <coviolo@libero.it>)
List pgsql-novice
tnx Tim an tnx Michael

I'll try tonight...Tomorrow I hope I have therefore resolved.

bye
Luca

>----Messaggio originale----
>Da: esiotrot@gmail.com
>Data: 09/06/2010 16.54
>A: "coviolo@libero.it"<coviolo@libero.it>
>Cc: <pgsql-novice@postgresql.org>
>Ogg: Re: [NOVICE] problem with variable
>
>On 9 June 2010 16:51, Michael Wood <esiotrot@gmail.com> wrote:
>> Hi
>>
>> On 9 June 2010 16:24, coviolo@libero.it <coviolo@libero.it> wrote:
>>> 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?
>>
>> Just a guess, but I think this is what you want:
>>
>> 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);'
>>
>> i.e. you want:
>>
>> CREATE TABLE table_name (x serial PRIMARY KEY
>> CHECK (column_name = "table_name"::text))
>> INHERITS (database_t);
>
>Sorry, I was talking nonsense.  You want column_name = 'table_name'
>but because the ' will be inside a quoted string, you need to double
>it.  So you were right.  Use ...nome_tabella = ''' || NEW.nome_tabella
>|| '''::text...
>
>--
>Michael Wood <esiotrot@gmail.com>
>
>--
>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 by date:

Previous
From: Michael Wood
Date:
Subject: Re: problem with variable
Next
From: Tom Lane
Date:
Subject: Re: Transaction manipulation commands in user defined c functions?