Re: [HACKERS] [PL/PgSQL] EXECUTE...USING enhancement proposal

2010-01-15 Thread Pavel Stehule
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

Re: [HACKERS] [PL/PgSQL] EXECUTE...USING enhancement proposal

2010-01-15 Thread 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('ALTER TABLE % ADD CHECK (col1=% AND co

Re: [HACKERS] [PL/PgSQL] EXECUTE...USING enhancement proposal

2010-01-15 Thread Pavel Stehule
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

Re: [HACKERS] [PL/PgSQL] EXECUTE...USING enhancement proposal

2010-01-15 Thread 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 rejected. Some composite and > nested v

Re: [HACKERS] [PL/PgSQL] EXECUTE...USING enhancement proposal

2010-01-14 Thread 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 values are significant break. see in arch