Postgres Pro
Downloads
Home   >   mailing lists

passing function's output into C function - Mailing list pgsql-general

From Kamil Kukura
Subject passing function's output into C function
Date
Msg-id bq4jdg$p1c$1@sea.gmane.org
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: PostgreSQL, MySQL, etc., was Re: PostgreSQL is much
Next
From: Jonathan Bartlett
Date:
Subject: Re: What is WAL used for?