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: 2005-11-30 03:35:32
Message-ID: 12504.1133321732@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

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

Responses

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-11-30 03:40:20 Re: BIN()
Previous Message Christopher Kings-Lynne 2005-11-30 03:08:08 Re: BIN()