Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BIN()
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
- Cc: Michael Fuhr <mike(at)fuhr(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Hackers <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: BIN()
- Date: Tue, 29 Nov 2005 22:35:32 -0500
- Message-id: <12504(dot)1133321732(at)sss(dot)pgh(dot)pa(dot)us>
Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes: >> test=> SELECT ltrim(textin(bit_out(12::bit(64))), '0'); >> ltrim >> ------- >> 1100 >> (1 row) > Sweeeeet. Good old i/o functions. Who needs the I/O functions? Just cast int to bit(n). regards, tom lane
- Follow-Ups:
- Re: BIN()
- From: Christopher Kings-Lynne
- Re: BIN()
- References:
- Prev by Date: Re: BIN()
- Next by Date: Re: BIN()
- Previous by thread: Re: BIN()
- Next by thread: Re: BIN()
- Indexes: