[Pdns-users] PowerDNS needs your thoughts on two important DNSSEC matters

[Peter van Dijk]

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/