Skip site navigation (1) Skip section navigation (2)

group by query?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: group by query?
Date: 2004-07-26 07:58:07
Message-ID: 4104B98F.7050006@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-hackers
In 7.4.3, my workmate came across the following situation he thought was 
odd.

Basically, we want to know why the group by and order by in the outer 
query get their variables from the inner query and not the select 
parameters in the outer query?

Chris


Attachment: subselect_groupby_test.sql
Description: text/plain (1.5 KB)

Responses

pgsql-hackers by date

Next:From: Justin CliftDate: 2004-07-26 08:13:30
Subject: Re: Improvements to PostgreSQL
Previous:From: Suresh TriDate: 2004-07-26 07:28:49
Subject: Stored procedures - Oracle vs postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group