Re: Converting integer to binary

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Chris Gamache <cgg007(at)yahoo(dot)com>
Cc: Stephen Quinney <stephen(dot)quinney(at)computing-services(dot)oxford(dot)ac(dot)uk>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Converting integer to binary
Date: 2004-06-10 22:27:31
Message-ID: 20040610222731.GA26006@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Jun 10, 2004 at 13:24:15 -0700,
Chris Gamache <cgg007(at)yahoo(dot)com> wrote:

Following up on the cast to bit idea, he could do something like
casting to bit(32). I don't think there is an easy way to get this
cast to string, so it may not completely solve his problem, depending
on what he was going to do with the binary representation. On teh other
hand, for some things a bit field might be more useful than a string.

area=> select 6::bit(32);
bit
----------------------------------
00000000000000000000000000000110
(1 row)

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message William Anthony Lim 2004-06-11 04:36:49 (No Subject)
Previous Message Chris Gamache 2004-06-10 20:24:15 Re: Converting integer to binary