BIN() - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject BIN()
Date
Msg-id 438D0B2B.20507@familyhealth.com.au
Whole thread Raw
Responses Re: BIN()  (Andrew Dunstan <andrew@dunslane.net>)
Re: BIN()  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-hackers
Hi guys,

How would I go about implementing MySQL's BIN() function easily in PL/SQL.

mysql> SELECT BIN(12);        -> '1100'

Basically it converts a bigint to a string containing 1's and 0's.

I've tried messing about with bit() types, but those types lack casts to 
text, etc.  And they are left padded with many zeros.

Any ideas?

Chris



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Please let us know if you will come to the PostgreSQL Anniversary
Next
From: Andrew Dunstan
Date:
Subject: Re: BIN()