Re: converting from bigint to bit to use bitwise operators

Adi,

Try an explicit cast into a text type and then into a bit string type.

Best,

Randall

On Monday, April 21, 2003, at 05:50 PM, Aditya wrote:

> For historical reasons, I have IPv4 addresses stored as bigint and I
> would
> like to convert them to dot-quad (ie. A.B.C.D) in a select. This is
> how I
> would normally do it (the remotehost column is the IP address as a
> bigint):
>
> select
> ((remotehost::bit varying(32) >> 24) & 11111111) || '.' ||
> ((remotehost::bit varying(32) & 11111100) >> 16) || '.' ||
> ((remotehost::bit varying(32) & 11110000) >> 8) || '.' ||
> ((remotehost::bit varying(32) & 11000000)) as ip,
> httpquery
> from
> weblogs
> ;
>
> however this complains:
>
> ERROR: Cannot cast type 'bigint' to 'bit varying'
>
> hints?
>
> Thanks,
> Adi
>
>
> ---------------------------(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
>