"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> select * from teleoperador;
> id | login | ip | tipo
> ----+----------+------------------------+------
> 0 | pablo | 10.0.0.106 | C
> 1 | builder | 10.0.0.107
> 10.0.0.107 | C
> 2 | reinaldo | 10.0.0.105 | C
> (3 rows)
Looks to me like you managed to store a carriage return or newline
character (\r or \n) in the ip column.
Is there a reason for using varchar rather than the inet datatype
for that column? inet would give you some error checking, which
you evidently need.
regards, tom lane