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 k...@spritelink.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
