Обсуждение: 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