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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org