Re: BIN()
- From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
- To: Michael Fuhr <mike(at)fuhr(dot)org>
- Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Hackers <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: BIN()
- Date: Wed, 30 Nov 2005 11:08:08 +0800
- Message-id: <438D1798(dot)4000006(at)familyhealth(dot)com(dot)au>
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
Home |
Main Index |
Thread Index