Hello, On Sep 3, 2012, at 21:23 , 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) I have now implemented this and it works perfectly. 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
