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@spritelink.net