diff options
author | ivan <ivan> | 2007-10-29 10:30:53 +0000 |
---|---|---|
committer | ivan <ivan> | 2007-10-29 10:30:53 +0000 |
commit | b91bcdff200acb281c58c4ba5ef8482b335ecdbc (patch) | |
tree | 76767f260e8babb87d7498638c0cce02c39339b3 /httemplate/edit/rate.cgi | |
parent | 9595e16b22b67dda69322cacbe69d518ae3db4cc (diff) |
mysql has no DISTINCT ON either, sigh
Diffstat (limited to 'httemplate/edit/rate.cgi')
-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; |