Re: Functions in a insert statement

Posted in 1999

Jonathan Leffler — Fri, 19 Feb 1999 08:50:10 -0800 (PST) — source: Informix-list mailing list archive (1991-1998)

On Fri, 19 Feb 1999, Olcay Sarioglu wrote: > What is wrong with the following SQL? > > insert into my_table values ( lower('AASDF') ); You've not listed a value in the values list. > Can't we use functions in insert SQLs? No. > Informix Dynamic Server Version 7.30.UC5 Hmmm...and all other versions too... Yours, Jonathan Leffler (jleffler@informix.com) #include <wish/I/was/skiing.h> Guardian of DBD::Informix v0.60 (v0.61_02) -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn