Re: Historical query - when was casting included in ISQL

On Mon, Jun 16, 2008 at 4:34 AM, Obnoxio The Clown <obnoxio@serendipita.com> wrote: > > iiug@perrior.net said: >> Apropos of a colleague being surprised to find >> >> SELECT some_datetime_year_to_second_field::DATE >> FROM a_table >> >> worked in ISQL V7.20 against a V9.30 database - does anyone recall >> when it was introduced to the ISQL product line? I can't find anything >> in the Guide To SQL V7.20 range of manuals in the online pubs. > > Maybe it's just handing the parsing off to the engine ... :o? No 'maybe' about it -- that is what is happening. ISQL does not actually understand the cast notation (any more than DB-Access does, incidentally), and it doesn't have to. All that's necessary is that it can recognize complete SQL statements and pass them to the server. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even.