Skip site navigation (1) Skip section navigation (2)

Re: BIN()

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: BIN()
Date: 2005-11-30 03:02:51
Message-ID: 20051130030251.GA32201@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Nov 29, 2005 at 07:57:58PM -0700, Michael Fuhr wrote:
> Any reason not to use sprintf("%b", $_[0])?

Or something like this in SQL or PL/pgSQL:

test=> SELECT ltrim(textin(bit_out(12::bit(64))), '0');
 ltrim 
-------
 1100
(1 row)

-- 
Michael Fuhr

In response to

  • Re: BIN() at 2005-11-30 02:57:58 from Michael Fuhr

Responses

  • Re: BIN() at 2005-11-30 03:08:08 from Christopher Kings-Lynne

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2005-11-30 03:04:05
Subject: Re: BIN()
Previous:From: Michael FuhrDate: 2005-11-30 02:57:58
Subject: Re: BIN()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group