Re: ecpg produces code that won't compile

Steve Clark wrote:

> ecpg_test.pgc:36: error: invalid application of `sizeof' to incomplete type
> `varchar_h_tunnel_active'

It seems that are you using implicit cast from varchar to inet. It
doesn't work in 8.3 anymore. You need to cast before calling the
function, ie, func(col::inet).

euler=# select '127.0.0.1/32'::varchar = '127.0.0.1/32'::inet;
ERROR:  operator does not exist: character varying = inet
LINHA 1: select '127.0.0.1/32'::varchar = '127.0.0.1/32'::inet;
                                         ^
DICA:  No operator matches the given name and argument type(s). You
might need to add explicit type casts.
euler=# select '127.0.0.1/32'::varchar::inet = '127.0.0.1/32'::inet;
  ?column?
----------
  t
(1 registro)


--
   Euler Taveira de Oliveira
   http://www.timbira.com/