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/