[postgis-users] How to convert binary to decimal ?

[Kevin Neufeld]

postgis=# select B'001011010'::integer;
  int4
------
    90
(1 row)


Tuomas Ruohonen wrote:
> Hi all,
> 
> For example I should get decimals from binary:
> 001011010 000001111 001101 000010
> to
> 90, 15, 13, 2
> Is there any function or just select statement that I can do this in 
> Postgre ?
> 
> Thanks !
> 
> ------------------------------------------------------------------------
> Jaa muistosi verkossa haluamiesi henkilöiden kanssa haluamiesi 
> henkilöiden kanssa. 
> <http://www.microsoft.com/finland/windows/windowslive/products/photos-share.aspx?tab=1>
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users