>>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])?
>
All very well and good, but it has to be PL/SQL preferably or PL/pgSQL.
I can write it in PL/PGSQL easily enough I guess but I was hoping
there was a neato shortcut.
Chris