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