group max() on dates with nulls

Posted in 1994

Bruce Momjian — Wed, 20 Apr 1994 03:05:27 GMT — source: Informix-list mailing list archive (1991-1998)

In the report AFTER GROUP statement below, assume c_var holds only NULL values: IF GROUP MAX(c_var) IS NOT NULL THEN PRINT GROUP MAX(c_var) USING "mm/dd/yy" END IF I would assume that the 'IF' statement would be false, and nothing should print. Instead, it prints "mm/dd/yy" on the report, which is the printing of a NULL GROUP MAX(). Does anyone know why? -- Bruce Momjian | 830 Blythe Avenue root%candle.uucp@bts.com | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)