In the following query the field 'memid' is varchar(8).
Is the error message below a bug?
select substr(memid,1,1) as memtp, substr(memid,2,4) as newx
from memmast group by memtp, newx
ERROR: column "memmast.memid" must appear in the GROUP BY clause or be used in
an aggregate function
--
Mike Nolan