Re: Substring Problem - Mailing list pgsql-general

From Stefan Schwarzer
Subject Re: Substring Problem
Date
Msg-id 1B2D0160-C72D-49B1-8A36-1406623B7A36@grid.unep.ch
Whole thread Raw
In response to Re: Substring Problem  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
>> COUNT(id) AS countofnumber FROM (SELECT * from downloads ) AS foo
>> GROUP BY stryearmonth ORDER BY stryearmonth ASC
>
> btw, whats the reason for the subselect?

Oh, right, looks a bit stupid like this. It's eventually being filled
with something more useful, upon the user's request. It's dynamically
(via PHP) extended to fulfill certain rules...

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: Strange behaviour - performance decreases after each TRUNCATE
Next
From: "Vyacheslav Kalinin"
Date:
Subject: Re: Couple of question on functions