pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: mrink@avaya.com
To: pgsql-sql@postgresql.org
Subject: using custom column names in a group by clause
Date: 13 Jul 2001 09:33:23 -0700
Message-ID: <3612a608.0107130833.58902406@posting.google.com> (raw)

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@avaya.com



view thread (2+ messages)  latest in thread

Message-ID: <3612a608.0107130833.58902406@posting.google.com>
Permalink:  ../3612a608.0107130833.58902406@posting.google.com/
Also on:    postgresql.org/message-id/3612a608.0107130833.58902406@posting.google.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mrink@avaya.com
  Subject: Re: using custom column names in a group by clause
  In-Reply-To: <3612a608.0107130833.58902406@posting.google.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox