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

Поиск
Список
Период
Сортировка
От mnihas@poczta.onet.pl (Michal O)
Тема Re: How to covert 'char' to 'inet'
Дата
Msg-id dc10011f.0207240040.4bb09b96@posting.google.com
обсуждение исходный текст
Ответ на Re: How to covert 'char' to 'inet'  (Andrew Sullivan <andrew@libertyrms.info>)
Ответы Re: How to covert 'char' to 'inet'  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: montie76@yahoo.com (montfort)
Дата:
Сообщение: Granting permission to root.
Следующее
От: Nelson Marisco
Дата:
Сообщение: Inquiry From Form [pgsql]