Marcel Gsteiger wrote:
Hi all Does anybody know how I could create a database function that accepts an INET parameter and reverse-lookups the hostname via DNS PTR lookup? Something like the dnsname command line utility in the djbdns package. I need this function for analyzing firewall logs stored in the database with ulogd.
You can write "unsafe" functions in any of the pl...u languages and also pl/sh and "C". Should be simple enough in whatever language you're most familiar with.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match