Re: Adding integers ( > 8 bytes) to an inet

On Tue, Sep 08, 2009 at 11:06:36AM -0400, Alvaro Herrera wrote:
> Kristian Larsson wrote:
>
> > And poking in pg_operator / pg_type seems to confirm this:
> >
> > nils=# SELECT (SELECT typname FROM pg_type WHERE typelem=oprleft), oprname, (SELECT typname FROM pg_type WHERE typelem=oprright) FROM pg_operator WHERE oprleft=(SELECT typelem FROM pg_type WHERE typname='_inet') AND oprname='+';
> > ?column? | oprname | ?column?
> > ----------+---------+----------
> > _inet | + | _int8
> > (1 row)
>
> That query is wrong -- type _inet is actually another way to spell
> inet[]. What you want is this, that also confirms your problem:

Sorry, I'm not intimately familiar with pg_operator ..

> > Am I doing it the wrong way? Bug?
>
> I'd say this is just a missing feature.

Would pgsql-bugs@ be the appropriate forum for a feature request?

I looked through the FAQ and Todo on the wiki and could not find
any already existing items to fix or not fix this.

Kind regards,
Kristian.

--
Kristian Larsson KLL-RIPE
+46 704 264511 kll(at)spritelink(dot)net