passing function's output into C function

Поиск
Список
Период
Сортировка
От Kamil Kukura
Тема passing function's output into C function
Дата
Msg-id bq4jdg$p1c$1@sea.gmane.org
обсуждение исходный текст
Ответы Re: passing function's output into C function  (Joe Conway <mail@joeconway.com>)
Re: passing function's output into C function  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I have table with column of type "inet". Then I have my own function
resolveip(text). It works okay when I store IP addres into column typed
as text or varchar. But with type of inet I run into this problem:


select host(acc_ip), resolveip(host(acc_ip)) from access_test limit 15

       host      |             resolveip
----------------+-----------------------------------
  212.80.81.141  | Bad IP address: '212.80.81.141.'
  212.80.81.141  | Bad IP address: '212.80.81.141'
  212.80.81.141  | Bad IP address: '212.80.81.141'
  212.80.81.141  | Bad IP address: '212.80.81.141'
  80.139.171.208 | Bad IP address: '80.139.171.208*'
  212.80.81.141  | Bad IP address: '212.80.81.1418'
  212.80.81.141  | Bad IP address: '212.80.81.1418'
  211.22.169.82  | Bad IP address: '211.22.169.828'
  81.0.234.52    |
  62.24.89.106   | Bad IP address: '62.24.89.106`'
  81.0.234.52    | Bad IP address: '81.0.234.526'
  212.80.81.141  | Bad IP address: '212.80.81.1415'
  62.84.131.161  | Bad IP address: '62.84.131.1615'
  212.80.81.141  | Bad IP address: '212.80.81.1415'
  195.122.204.15 | e0-a11.b1.lan.prg.vol.cz

Is there something I'm missing when data are passed from function to
function?

--
Kamil Kukura


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

Предыдущее
От: Jonathan Bartlett
Дата:
Сообщение: Re: PostgreSQL, MySQL, etc., was Re: PostgreSQL is much
Следующее
От: Jonathan Bartlett
Дата:
Сообщение: Re: What is WAL used for?