diff options
Diffstat (limited to 'httemplate/edit')
| -rw-r--r-- | httemplate/edit/rate.cgi | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/httemplate/edit/rate.cgi b/httemplate/edit/rate.cgi index 72a04c339..55fe319cf 100644 --- a/httemplate/edit/rate.cgi +++ b/httemplate/edit/rate.cgi @@ -58,17 +58,21 @@ Rate plan <TH><FONT SIZE=-1>Granularity</FONT></TH> </TR> % foreach my $rate_region ( -% sort { lc($a->regionname) cmp lc($b->regionname) } +% #sort { lc($a->regionname) cmp lc($b->regionname) } % qsearch({ -% 'select' => 'DISTINCT ON ( regionnum ) rate_region.*', % 'table' => 'rate_region', % 'hashref' => {}, +% 'order_by' => 'ORDER BY lc(regionname)', +% +% #'select' => 'DISTINCT ON ( regionnum ) rate_region.*', +% #... % #'addl_from' => 'INNER JOIN rate_prefix USING ( regionnum )', % #'extra_sql' => "WHERE countrycode != '1'", % % # 'ORDER BY regionname' % # ERROR: SELECT DISTINCT ON expressions must % # match initial ORDER BY expressions +% # also, DISTINCT ON is a Pg-ism % }) % ) { % my $n = $rate_region->regionnum; |