On Thu, Jun 10, 2004 at 05:27:31PM -0500, Bruno Wolff III wrote: > 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)
That would probably work for me in this case as I am interfacing to postgresql via the Perl DBI layer. With perl reading out that field would give me a string representation. Thanks for the tips, Stephen Quinney ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
