Michael Fuhr wrote:
On Tue, Nov 29, 2005 at 09:46:13PM -0500, Andrew Dunstan wrote:create or replace function bin(bigint) returns text language plperl as $$ my $arg = $_[0] + 0; my $res = ""; while($arg) { $res = ($arg % 2) . $res; $arg >>= 1; } return $res; $$;Any reason not to use sprintf("%b", $_[0])?
TIMTOWTDI, as we have seen (also I had forgotten %b if I ever knew it) cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
