2010/1/15 Vincenzo Romano :
> 2010/1/15 Pavel Stehule :
>> I disagree with this functionality for USING clause. Main parser
>> doesn't support some enhanced syntax. But we can discus about some
>> function 'printf' or 'format' that can help with similar task.
>>
>> some like
>>
>> EXECUTE format('A
2010/1/15 Pavel Stehule :
> I disagree with this functionality for USING clause. Main parser
> doesn't support some enhanced syntax. But we can discus about some
> function 'printf' or 'format' that can help with similar task.
>
> some like
>
> EXECUTE format('ALTER TABLE % ADD CHECK (col1=% AND co
2010/1/15 Vincenzo Romano :
> 2010/1/14 Pavel Stehule :
>> Hello
>>
>> I thing, so this is bad idea.
>>
>> a) this behave depends on DDL implementation, not plpgsql implementation
>>
>> b) proposed implementation needs some escape magic. This was first
>> implementation of USING clause and it was r
2010/1/14 Pavel Stehule :
> Hello
>
> I thing, so this is bad idea.
>
> a) this behave depends on DDL implementation, not plpgsql implementation
>
> b) proposed implementation needs some escape magic. This was first
> implementation of USING clause and it was rejected. Some composite and
> nested v
Hello
I thing, so this is bad idea.
a) this behave depends on DDL implementation, not plpgsql implementation
b) proposed implementation needs some escape magic. This was first
implementation of USING clause and it was rejected. Some composite and
nested values are significant break.
see in arch
Hi all.
There's currently a limitation in the v8.4.2 implementation of the
EXECUTE...USING predicate in PL/PgSQL which prevents you from
exploiting the USING-supplied value list with DDL commands.
For example:
CREATE TABLE test ( i int );
...
EXECUTE 'ALTER TABLE test ALTER COLUMN i SET DEFAULT $1