From: | Kamil Kukura <kamk(at)volny(dot)cz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | passing function's output into C function |
Date: | 2003-11-27 10:24:41 |
Message-ID: | bq4jdg$p1c$1@sea.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Travers | 2003-11-27 10:52:30 | Re: PostgreSQL, MySQL, etc., was Re: PostgreSQL is much faster than MySQL, only when... |
Previous Message | Unihost Web Hosting | 2003-11-27 10:02:16 | Re: Open source data modeling tools for PostgreSQL |