Hello, On Sep 3, 2012, at 21:15 , Peter van Dijk wrote:
> Great tips from #postgresql: > 1. ORDER BY col USING ~<~ - apparently undocumented, but it sorts the right > way. > > 1) can use indexes that use the text_pattern_ops opclass Comparisons like < and > would then be replaced by ~<~ and ~>~ etcetera. "the obvious choice of index would be records (domain_id, ordername text_pattern_ops)" (thanks to Andrew 'RhodiumToad' Gierth of #postgresql) Kind regards, -- Peter van Dijk Netherlabs Computer Consulting BV - http://www.netherlabs.nl/ _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
