converting from text -> inet ... possible?
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
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
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
Is this a TODO item?
Yup. Somehow there is a conversion from inet to text, but not the other
way around.
- Thomas
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