www/166662: www/asterisk-stat - pgsql select substring() problem

[Veselin Slavov]

The following reply was made to PR ports/166662; it has been noted by GNATS.

From: Veselin Slavov <vess at slavof.net>
To: bug-followup at FreeBSD.org
Cc:  
Subject: Re: www/166662: www/asterisk-stat - pgsql select substring() problem
Date: Thu, 05 Apr 2012 11:55:28 +0300

 Even better - optimized query with order:
 
 $QUERY = "SELECT cast(calldate as date) AS day, sum(duration) AS
 calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP
 BY cast(calldate as date) order by 1 desc"; //extract(DAY from calldate)