Обсуждение: 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 it possible to go from text->inet in v7.0.3?  if not, is it in v7.1?

Seems to not be in 7.1 either.
                        - Thomas

how hard would it be to rectify before beta4 is put out?  i'm doing a
manual dump/restore to get my data from text->inet ... not elegant, but it
works ... ::)

On Thu, 18 Jan 2001, Thomas Lockhart wrote:

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

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

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?

> 
> 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,
Pennsylvania19026
 

> 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,
Pennsylvania19026