using custom column names in a group by clause

From: mrink(at)avaya(dot)com (Matt Rinkenberger)
To: pgsql-sql(at)postgresql(dot)org
Subject: using custom column names in a group by clause
Date: 2001-07-13 16:33:23
Message-ID: 3612a608.0107130833.58902406@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

The following select sets two custom column names using the same
original column name. When I try to include a custom column name in a
group by clause I get ORA-00904: invalid column name from Oracle. How
can I access a column name I created in the group by clause?

Here's the SQL: DISP is the column causing the error

select userid,matlid,wsid,
substr(note,instr(note,'Status') + 8,(instr(note,',',1,3) -
(instr(note,'Status') + 8))) as DISP,
sum(substr(note,instr(note,'Qty') + 5,(instr(note,',',1,1) -
(instr(note,'Qty') + 5)))) as QTY,
action
from ise_prodordlog
where userid = '4500925'
and action in ('CompleteItem','UndoCompleteItem')
and actiontime >= to_date('06/20/2001 00:00:00','MM/DD/YYYY
HH24:MI:SS')
and actiontime < to_date('06/30/2001 00:00:00','MM/DD/YYYY
HH24:MI:SS')
group by userid,matlid,wsid,DISP,action
order by userid,matlid,wsid,DISP,action;

Matt Rinkenberger
Avaya, Inc.
mrink(at)avaya(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-07-13 16:39:44 Re: Date Validation?
Previous Message Peter Eisentraut 2001-07-13 16:18:19 Re: How can we match a condition among 2 diff. tables?