index on calculated column

Posted in 1998

Joseph Cullipher — Wed, 17 Jun 1998 12:58:33 -0500 (CDT) — source: Informix-list mailing list archive (1991-1998)

I am trying to create an index on a calculated column but keep getting a syntax error. create temp table t1 (started smallint,finished smallint); create index t1 on t1(started-finished) I couldn't find anything in the manuals that say I cannot do this but it still won't let me. Any suggestions on how I can accomplish this task? ------------------------------------------------------------------------- Joseph Cullipher <joseph@cannonexpress.com> Standard Disclaimers Apply -------------------------------------------------------------------------