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