[SAC] Trac postgres conversion

Frank Warmerdam warmerdam at pobox.com
Mon Jul 6 12:47:19 EDT 2009

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!


Thanks for the clear analysis.  I will try and fixup the other trac's today.

Best regards,

I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent

More information about the Sac mailing list