RE: temp tables and serial columns

Bill Hamilton said: > That would be nice.Or just allow something like:"select * from foo into > temp t serialasint;"A serial should be integer in the temp.A serial8 > should be int8.If the table does not have a serial or you did not select > it, then the serialasint gets ignored. Just a thought: why don't you CREATE TEMP TABLE foo ( serno INT,... ... ... ) WITH NO LOG; Then run your select as INSERT INTO foo SELECT * FROM bar... ??? -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.