converting from text -> inet ... possible?

Started by The Hermit Hackeralmost 25 years ago5 messages
#1The Hermit Hacker
scrappy@hub.org

I scanned the archives, and one person asked it back in July, but there
doesn't appear to be any followup ...

Is it possible to go from text->inet in v7.0.3? if not, is it in v7.1?

the following doesn't work:

template1=# select '216.126.84.1'::text::inet;
ERROR: Cannot cast type 'text' to 'inet'

but I could be missing something in the docs?

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org

#2Bruce Momjian
pgman@candle.pha.pa.us
In reply to: The Hermit Hacker (#1)
Re: converting from text -> inet ... possible?

Is this a TODO item?

I scanned the archives, and one person asked it back in July, but there
doesn't appear to be any followup ...

Is it possible to go from text->inet in v7.0.3? if not, is it in v7.1?

the following doesn't work:

template1=# select '216.126.84.1'::text::inet;
ERROR: Cannot cast type 'text' to 'inet'

but I could be missing something in the docs?

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
#3Hannu Krosing
hannu@tm.ee
In reply to: The Hermit Hacker (#1)
Re: converting from text -> inet ... possible?

The Hermit Hacker wrote:

I scanned the archives, and one person asked it back in July, but there
doesn't appear to be any followup ...

Is it possible to go from text->inet in v7.0.3? if not, is it in v7.1?

the following doesn't work:

template1=# select '216.126.84.1'::text::inet;
ERROR: Cannot cast type 'text' to 'inet'

You could use something like that:
hannu=# select inet_in(textout('127.0.0.1/24'::text)) as n;
n
--------------
127.0.0.1/24
(1 row)
-------------------------------
Hannu

#4Thomas Lockhart
lockhart@alumni.caltech.edu
In reply to: Bruce Momjian (#2)
Re: converting from text -> inet ... possible?

Is this a TODO item?

Yup. Somehow there is a conversion from inet to text, but not the other
way around.

- Thomas

#5Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Thomas Lockhart (#4)
Re: converting from text -> inet ... possible?

Added to TODO:

* Add conversion function from text to inet

Is this a TODO item?

Yup. Somehow there is a conversion from inet to text, but not the other
way around.

- Thomas

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026