Re: How to covert 'char' to 'inet'

Thank you. What I did was:

  inet(trim(both ' ' from server_ip::text))

and worked fine. Convertion to 'text' was needed.
Do you know how time consuming it is ? Is there more efficient way ?

Best regards
  Michal Otroszczenko

> > I've tried cast to convert char to inet, but that is no good waw :((.
> > Does anybody know how to do that ?
>
> Try trim(charfield)::inet.  Worked for me.  I think the problem is
> that char is padded.
>
> A