Hello hackers
I think about solution multi values insert from TODO. There is one "hack"
solution .. transformation from VALUES (a), (b) into SELECT a UNION ALL
SELECT b. Or there is next (more general) solution .. implementation of
table value constructor http://savage.net.au/SQL/sql-2003-2.bnf .
With TVC we can do:
INSERT INTO ... VALUES(r1), (r2), ...;
SELECT FROM a JOIN VALUES (r1), (r2), ...;
CREATE VIEW ... AS VALUES (r1), (r2), ...;
It's propably F641 sql-2003 noncore feature
Best regards
Pavel Stehule
_________________________________________________________________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci.
http://messenger.msn.cz/
---------------------------(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
