Re: [GENERAL] index scan and functions

2010-07-23 Thread arno
Le mardi 20 juillet 2010, à 10:11:21 +0200, Harald a écrit : In article 20100719162547.ga17...@localhost, arno a...@renevier.net writes: Thanks, that's exactly what I was looking for. No, I'd say you're looking for the ip4r package which provides an indexable IP address range type

[GENERAL] index scan and functions

2010-07-19 Thread arno
Hi, In a table, I've some geoip informations with indexes to two colums \d geoip Table « public.geoip » Colonne | Type | Modificateurs --+--+--- begin_ip | bigint | end_ip | bigint | country | character(2) | Index :

Re: [GENERAL] index scan and functions

2010-07-19 Thread arno
Le lundi 19 juillet 2010, à 17:09:02 +0100, Sam a écrit : On Mon, Jul 19, 2010 at 05:55:48PM +0200, arno wrote: But when using a custom function to compute my where parameter inet_to_bigint is a function that transform an inet address its integer representation. Is there a way