PFC <[EMAIL PROTECTED]> writes: > > I was also vaguely pondering whether all the DDL commands could be > > generalized to receive or send COPY formatted data for repeated execution. > > It would be neat to be able to prepare an UPDATE with placeholders and > > stream data in COPY format as parameters to the UPDATE to execute it > > thousands or millions of times without any protocol overhead or network > > pipeline stalls. > > MySQL already does this for INSERT : > INSERT INTO x (a,b) VALUES (1,2), (3,4), (5,6)...;
Does MySQL really let you stream that? Trying to do syntax like that in Postgres wouldn't work because the parser would try to build up a parse tree for the whole statement before running the command. -- greg ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match