[SAC] Trac postgres conversion

[Astrid Emde]

Frank Warmerdam schrieb:
> Jason Birch wrote:
>> I believe that all of the canned report 6 "All Tickets By Milestone 
>> (Including closed)" are broken because of this statement:
>>
>> ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'), 
>>         (CASE status WHEN 'closed' THEN modified ELSE (-1)*p.value 
>> END) DESC
>>
>> The fixed version (referencing the underlying column for modified and 
>> casting the p.value) looks something like
>> ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'), 
>>         (CASE status WHEN 'closed' THEN changetime ELSE (-1 * 
>> CAST(p.value AS numeric)) END) DESC
>>
>> I've fixed MapGuide's and FDO's, but it looks like others are broken, 
>> such as:
>>
>> http://trac.osgeo.org/gdal/report/6
>>
>> Other than that this seems to have gone well.  Great job folks!
>
> Jason,
>
> Thanks for the clear analysis.  I will try and fixup the other trac's 
> today.
>
> Best regards,
>
Hello Frank, hello Jason,

thanks for all your help. Christoph already fixed the reports for 
mapbender today.

Best regards astrid

-- 

Mit freundlichen Grüßen

Astrid Emde
----------------------------------

AGIT Konferenz 2009
8.-10. Juli 2009 in Salzburg
http://www.mapbender.org/Mapbender_on_Agit_2009

---------------------------------- 

 Astrid Emde
 WhereGroup GmbH & Co.KG
 Siemensstraße 8
 53121 Bonn
 Germany

 Fon: +49(0)228 90 90 38 - 19
 Fax: +49(0)228 90 90 38 - 11

 astrid.emde at wheregroup.com
 www.wheregroup.com

 Amtsgericht Bonn, HRA 6788
 -------------------------------
 Komplementärin:
 WhereGroup Verwaltungs GmbH
 vertreten durch:
 Arnulf Christl, Olaf Knopp, Peter Stamm
 ---------------------------------------