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 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. Thanks, I'l

Re: [GENERAL] index scan and functions

2010-07-20 Thread Harald Fuchs
In article <20100719162547.ga17...@localhost>, arno 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

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

Re: [GENERAL] index scan and functions

2010-07-19 Thread Sam Mason
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, either to put function return value in a variable, or to tell > pos

[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 : "geoip_b