Ow Mun Heng wrote:
Hi Guys, Searching the net didn't give me much clues as to how to convert a Decimal number into BINARY.
well, a decimal number is a fixed point number stored in a modified BCD format, which optionally can contain a decimal fractional component.
you likely would want to convert it to a INTEGER or BIGINT first, then cats it to BIT(n) where N is the number of bits you want.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
