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

[Peter van Dijk]

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/