Paul,

> select cast(rdb$security_class as varchar(80)), 1
> from rdb$database
> group by 1, 2
>
> select cast(rdb$security_class as varchar(80)), 1
> from rdb$database
> group by 2, 1
>
> The first one passes, and the second one fails.

What is the error message?


Sean

P.S. FYI: the SQL standard *only* allows for ordinal values in the
GROUP BY clause...