Chris Travers writes:
> On Wed, Aug 22, 2012 at 8:04 AM, Tom Lane wrote:
>> Chris Travers writes:
> mtech_test=# explain analyze select (account_heading__list()).* group by accno
>> Hm, that really ought to throw an error, since you have ungrouped
>> columns in the result. Not sure why it does
On Wed, Aug 22, 2012 at 8:04 AM, Tom Lane wrote:
> Chris Travers writes:
>> It's when we add group by that things appear broken. Note it starts
>> returning 196 (14 x 14) records, which suggests a cross join against
>> itself.
>
>> mtech_test=# explain analyze select (account_heading__list()).*
Chris Travers writes:
> It's when we add group by that things appear broken. Note it starts
> returning 196 (14 x 14) records, which suggests a cross join against
> itself.
> mtech_test=# explain analyze select (account_heading__list()).* group by accno
> mtech_test-# ;
Hm, that really ought to
Hi all;
In some of my tests regarding set-returning functions I came across
some very strange behavior. Group by seems to have very strange (and
inconsistent) behavior when connected to the use of a set-returning
function in a column list.
Consider the following function which returns a list of
JOHN_MCY wrote:
hai,
I am new to SQL...
I am trying to get the result of some mathematical calculation with
group by some key.
I can get the result without grouping. here with i specified my table
information and the SQL i have used to get the result..
can anybody
hai,
I am new to SQL...
I am trying to get the result of some mathematical calculation with
group by some key.
I can get the result without grouping. here with i specified my table
information and the SQL i have used to get the result..
can anybody help me to write
Dear Tom,
Thanks for suggestion. I upgrade my database to 8.1.3 and it is solve
the problem :-)
Regards,
Ferenc
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
YourSoft <[EMAIL PROTECTED]> writes:
> 1)
> select kifejezes, count(kifejezes) from summary group by kifejezes
> having count(kifejezes)>1;
> the result is:
> kifejezes| count
> -+---
> csúcscsajok | 2
> jászszentandrás |
Dear Developers,
There is a possible bug in 'select ... group by' SQL.
I reported it on the bugreport form on the web. (I think it number is
2416?). But no any reaction to it.
It is not problem for me, I make my results in other way. But it is
possible problem for other pepoples.
I reproduced
