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