On Tue, Oct 17, 2006 at 02:41:25PM -0400, Mark Woodward wrote:
> The output column "ycis_id" is unabiguously a single value with regards to
> the query. Shouldn't PostgreSQL "know" this? AFAIR, I think I've used this
> exact type of query before either on PostgreSQL or another system, maybe
> Oracle, and it did work.
Doesn't work in Oracle 10g:
SELECT ycis_id, tindex from x where ycis_id = 15;
YCIS_ID TINDEX
======= ======
15 10
15 20
SELECT ycis_id, min(tindex), avg(tindex) from x where ycis_id = 15;
ORA-00937: not a single-group group function
SELECT ycis_id, min(tindex), avg(tindex) from x where ycis_id = 15 GROUP BY
ycis_id;
YCIS_ID MIN(TINDEX) AVG(TINDEX)
======= =========== ===========
15 10 15
--Joe
--
Joe Sunday <[EMAIL PROTECTED]> http://www.csh.rit.edu/~sunday/
Computer Science House, Rochester Inst. Of Technology
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
