Port Bug Report: Syntax Error from ( group by ) select

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Jin Beom, Son
Your email address : cunix(at)hitel(dot)net

Category : runtime: front-end
Severity : critical

Summary: Syntax Error from ( group by ) select

System Configuration
--------------------
Operating System : Solaris2.6 ( sparc )

PostgreSQL version : 6.5

Compiler used : gcc-2.8.1

Hardware:
---------
Sparc4 / 96MB /

Versions of other tools:
------------------------
gmake 3.75
flex 2.5.41.25
bison

--------------------------------------------------------------------------

Problem Description:
--------------------
select a.* from web_menu a, group_table b, user_group c, web_group_menu d where
c.id = 'js777' and c.group_id = b.group_id and d.group_id = b.group_id and d.me
= a.me group by a.me, a.up, a.menu_name, a.hyper_link_tag, a.memo order by up, m
e;

--------------------------------------------------------------------------

Test Case:
----------
QUERY: select a.* from web_menu a, group_table b, user_group c, web_group_menu d
where c.id = 'js777' and c.group_id = b.group_id and d.group_id = b.group_id an
d d.me = a.me group by a.me, a.up, a.menu_name, a.hyper_link_tag, a.memo order b
y up, me;
ERROR: Illegal use of aggregates or non-group column in target list

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------