Re: Converting integer to binary - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: Converting integer to binary
Date
Msg-id 20040610222731.GA26006@wolff.to
Whole thread Raw
In response to Re: Converting integer to binary  (Chris Gamache <cgg007@yahoo.com>)
Responses Re: Converting integer to binary  (Stephen Quinney <stephen.quinney@computing-services.oxford.ac.uk>)
List pgsql-sql
On Thu, Jun 10, 2004 at 13:24:15 -0700, Chris Gamache <cgg007@yahoo.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)



pgsql-sql by date:

Previous
From: Chris Gamache
Date:
Subject: Re: Converting integer to binary
Next
From: "William Anthony Lim"
Date:
Subject: (No Subject)