On Tue, Feb 24, 2004 at 01:07:10PM +0100, Eric Jain wrote:
> > <http://word-to-the-wise.com/ipr.tgz> is a datatype that contains
> > a range of IPv4 addresses, and which has the various operators to
> > make it GIST indexable.
> Great, this looks very promising.
> > No cast operators between ipr and inet types.
> Any way to work around this, short of dumping and reloading tables?
> SELECT ipr '184.108.40.206'; -- Okay
> SELECT ipr text(inet '220.127.116.11'); -- Syntax error, of course
> SELECT ipr(text(inet '18.104.22.168')); -- Function does not exist, of course
There's probably some horrible SQL hack that would let you do it, but
I should add some casting code anyway. Shouldn't be too painful to do -
I'll try and get that, and some minimal documentation out today.
In response to
pgsql-performance by date
|Next:||From: Hans-Jürgen Schönig||Date: 2004-02-24 17:40:25|
|Subject: Re: [HACKERS] [SQL] Materialized View Summary|
|Previous:||From: Richard Huxton||Date: 2004-02-24 17:11:20|
|Subject: Re: [SQL] Materialized View Summary|