I have searched around but I cannot see any standard way in PostgreSQL
to convert from an integer into a binary representation.
i.e. I want to do:
16 ==> 10000
32 ==> 100000
64 ==> 1000000
96 ==> 1100000
etc..
Now I have an algorithm to do it so I could write an SQL function, I
guess. If there's a standard way to do it though that would be quite nice.
Thanks in advance,
Stephen Quinney