Re: CAST(ipaddress as text) -- HOW?

hi,

ipaddress::text

is resulting in

ERROR: Cannot cast type 'cidr' to 'text'

how else we can???

Thankx.

On Tue, 17 Jul 2001, omid omoomi wrote:

> ie,
> ipaddrss::text
>
> >From: Bhuvan A <bhuvansql(at)yahoo(dot)com>
> >To: pgsql-sql(at)postgresql(dot)org
> >Subject: [SQL] CAST(ipaddress as text) -- HOW?
> >Date: Tue, 17 Jul 2001 19:35:53 +0530 (IST)
> >
> >
> >hi all,
> >
> >how can we cast an ipaddress(type cidr) to any other type?
> >
> >thankx in advance..
> >
> >
> >Regards,
> >
> >Bhuvaneswar.
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 3: if posting/reading through Usenet, please send an appropriate
> >subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> >message can get through to the mailing list cleanly
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>