max(r,x) treated as RATIONAL when x is CHAR
Posted: Tue May 27, 2008 1:36 pm
I tried comparing MAX(r,x), where x is of type CHAR, with a character string literal. I got a syntax error saying that I was trying to compare a RATIONAL with a CHAR.
Easy test case:
Max(relation{tuple{x 'abc'}},x)
works okay.
Max(relation{tuple{x 'abc'}},x) = 'abc'
gives the error.
Hugh
Easy test case:
Max(relation{tuple{x 'abc'}},x)
works okay.
Max(relation{tuple{x 'abc'}},x) = 'abc'
gives the error.
Hugh