Postgres Pro
Downloads
Home   >   mailing lists

Re: BIN() - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: BIN()
Date
Msg-id 438D1798.4000006@familyhealth.com.au
Whole thread Raw
In response to Re: BIN()  (Michael Fuhr <mike@fuhr.org>)
Responses Re: BIN()  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
> Or something like this in SQL or PL/pgSQL:
> 
> test=> SELECT ltrim(textin(bit_out(12::bit(64))), '0');
>  ltrim 
> -------
>  1100
> (1 row)

Sweeeeet.  Good old i/o functions.

Chris

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: BIN()
Next
From: Tom Lane
Date:
Subject: Re: BIN()