Re: temp tables and serial columns

Posted in 2007

Obnoxio The Clown — Fri, 9 Mar 2007 19:58:55 -0000 (GMT) — source: Usenet: comp.databases.informix

Bill64bits said: > > "fred" <fred@bloomberg.com> wrote in message > news:45F1B16C.7020105@bloomberg.com... >> select INT::serial_column, .... >> INTO TEMP fred; > > So, if there are 100 columns in the table and I want them all in the > temp, I must list all 100 columns in the select > (instead of *) so that I can cast one column to INT ? > That seems lame. > I guess IBM does not cater to lazy programmers or dba's. :-) It certainly doesn't cater to programmers who can't be arsed to learn a bit of vi or awk. :op -- 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.