On Thu, Jun 10, 2004 at 13:24:15 -0700, Chris Gamache <[EMAIL PROTECTED]> 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) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html