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


Your name : Jin Beom, Son
Your email address : cunix@hitel.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:
---------


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

Search Discussions

  • Jin.Beom, Son at Jun 23, 1999 at 7:26 am
    ============================================================================
    POSTGRESQL BUG REPORT TEMPLATE
    ============================================================================


    Your name : Jin Beom, Son
    Your email address : cunix@hitel.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.4
    bison 1.25

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

    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:
    ---------


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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedJun 23, '99 at 7:24a
activeJun 23, '99 at 7:26a
posts2
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Jin.Beom, Son: 2 posts

People

Translate

site design / logo © 2022 Grokbase